Questions within the last month with more than x score.
Q&A for committed Christians, experts in Christianity and those interested in learning more
-- Recent High Scoring Questions -- Questions within the last month with more than x score. DECLARE @MinimumScore int SET @MinimumScore = ##MinimumScore## SELECT TOP 50 Score, CreationDate, PostTypeId, Id AS [Post Link], Title FROM Posts WHERE Score >= @MinimumScore AND CreationDate >= DATEADD(MONTH, -1, GETDATE()) -- AND PostTypeId = ORDER BY Score DESC, CreationDate DESC;