0

Please login or register to vote for this query.

(click on this box to dismiss)

See the total up and down votes for answers and questions for a given user.

Q&A about the site for Ubuntu users and developers

DECLARE @userid int = ##UserID##

select
 (case 
  when p.posttypeid = 1 then 'Question'
  when p.posttypeid = 2 then 'Answer'
end) as [Post Type],
(case
  when v.votetypeid = 2 then 'Up Vote'
  when v.votetypeid = 3 then 'Down Vote'
end) as [Vote Type], 
count(*) As Votes
from votes v join posts p on v.postid = p.id
where v.votetypeid in (2,3) and v.userid = @userid
group by p.posttypeid, v.votetypeid

view current version

edited jul 27 10

created jul 27 10 jrista