Q&A for professionals and students of engineering
DECLARE @UserId int = ##UserId## --select * from VoteTypes; select case when VoteTypeId = 1 then 15 when VoteTypeId = 2 then 10 else 0 end ,Votes.*, PostId as [Post Link] from Votes where PostId in (select Id from Posts where OwnerUserId = @UserId);