0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for project managers

DECLARE @UserId int = ##UserId##
-- Enter Query Title
-- Enter Query Description

select  a.* 
--count(case when a. VoteTypeId = 2 then 1 end),
--count(case when a. VoteTypeId = 3 then 1 end)
from PostFeedback a
inner join Posts b on a.PostId = b.Id
inner join PostTypes c on b.PostTypeId = c.Id
where b.OwnerUserId = @UserId;

view current version

edited aug 29 13

created aug 16 13 Eat A Peach