0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions within the last n days with more than x score.

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

-- Recent High Scoring Questions
-- Questions within the last n days with more than x score.
SET nocount ON
DECLARE @BEGINDATE datetime
SELECT @BEGINDATE = DateAdd(d, -##WithinDays##, GETDATE())
SET nocount OFF

SELECT Score, CreationDate, Title
FROM Posts
WHERE Score > ##MinimumVotes##
AND CreationDate >= @BEGINDATE
ORDER BY Score DESC, CreationDate DESC;

fork query

created feb 17 11 anonymous