Recent Comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

DevOps Meta

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

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

SELECT 

    ROW_NUMBER() OVER (ORDER BY c.Score DESC, c.CreationDate DESC) AS 'ID',
    c.postID [Post Link],
    c.Score,
    c.CreationDate,
    u.DisplayName,
    Text

FROM Comments AS c
JOIN Users AS u ON u.Id = c.PostId

WHERE c.UserId = @UserId

ORDER BY c.Score DESC, c.CreationDate DESC

Enter Parameters

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