0

Please login or register to vote for this query.

(click on this box to dismiss)

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],
    u.DisplayName AS 'User',
    u.Reputation AS 'Reputation',
    p.Title AS 'Post',
    p.CommentCount AS 'Comments',
    IIF(p.PostTypeId = 1, 'Q', 'A') AS 'QA',
    c.Score AS 'Score',
    c.CreationDate 'Date',
    c.Text AS 'Comment'

FROM Comments AS c
JOIN Posts AS p ON p.Id = c.PostId
--JOIN Posts AS pc ON pc.ParentId = c.PostId
JOIN Users AS u ON u.Id = p.OwnerUserId

WHERE c.UserId = @UserId

ORDER BY c.Score DESC, c.CreationDate DESC

view current version

edited feb 28

created feb 1 22 VBasic2008