1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

DECLARE @UserId INT = '##UserId:INT##'

DECLARE @Year INT = '##Year:INT?0##'
SELECT @Year = IIF(@Year = 0, YEAR(CURRENT_TIMESTAMP), @Year)

SELECT
    ROW_NUMBER() OVER (ORDER BY c.CreationDate) AS #,
    c.Id,
    c.PostId,
    c.Score,
    c.Text,
    c.CreationDate

FROM
    Comments c

WHERE
    c.UserId = @UserId
    AND YEAR(c.CreationDate) = @Year    

ORDER BY
    c.CreationDate

fork query

edited feb 27

created feb 26 VBasic2008