1

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##
DECLARE @TopCount int = ##Count:int?10##

SELECT TOP 10 
    p.Id AS [Post Link],
    u.Id AS [User Link],
    p.ViewCount AS Views,
    p.AnswerCount AS Answers,
    p.AcceptedAnswerId AS AID,
    a.Id AS MyID,
    p.Score AS QScore,
    a.Score AS MyScore,
    p.CommentCount AS QComm,
    a.CommentCount AS MyComm,
    p.Tags

FROM Posts a 
JOIN Posts p ON a.ParentID=p.Id
JOIN Users u ON p.OwnerUserId=u.Id
WHERE a.OwnerUserId=@UserId
ORDER BY Views DESC

view current version

edited feb 24

created feb 24 VBasic2008