Pundit Badge advancement

2

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

-- Pundit Badge advancement
-- Retrieve your comments with a score >= 2

DECLARE @UserId int = ##UserId##

SELECT 
    Text, 
    Score, 
    CAST(Score * 100 / 5 AS VARCHAR)+'%' Advancement, 
    PostId AS [Post Link]
FROM 
    Comments 
WHERE 
    UserId = @UserId 
    AND Score >= 2 
ORDER BY 
    Score DESC, 
    CreationDate ASC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results