0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

created feb 17 11 anonymous