User Comments by Year

1

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

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
    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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results