Q&A for professional and enthusiast programmers
DECLARE @UserID int = 284758 DECLARE @Date DATETIME = '07/01/2012' SELECT U.DisplayName, P.Id, P2.Tags FROM Posts P INNER JOIN Users U ON P.OwnerUserId = U.Id INNER JOIN Posts P2 ON P2.Id = P.ParentId WHERE U.Id = @UserID AND P.CreationDate BETWEEN DATEADD(dd,-30,@Date) AND @Date AND P.PostTypeId = 2