Questions within the last n days 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 n days with more than x score.
SET @MinimumScore = ##MinimumScore##
SET @WithinDays = ##WithinDays##
SELECT TOP 50 Score, CreationDate, Id AS [Post Link], Title
WHERE Score >= @MinimumScore
AND CreationDate >= DATEADD(DAY, -@WithinDays, GETDATE())
ORDER BY Score DESC, CreationDate DESC;