0

Please login or register to vote for this query.

(click on this box to dismiss)

How many comments do I have for each score.

Q&A for enthusiasts and scholars of mythology and folklore

DECLARE @UserId int = ##UserId##

SELECT 
    vt.Name, v.*
FROM 
    Votes as v
    JOIN Users as u ON u.Id = v.UserId AND u.DisplayName like 'Eric Lippert'
    JOIN VoteTypes vt on vt.Id = v.VoteTypeId

fork query

edited feb 26 12 jon.doe7442

created may 25 10 sam.saffron