Q&A for people looking to bypass life's everyday problems with simple tricks
DECLARE @UserId int = ##UserId## --select * from VoteTypes; select case when VoteTypeId = 1 then 15 when VoteTypeId = 2 then 10 when VoteTypeId = 3 then -2 when VoteTypeId = 8 then -BountyAmount when VoteTypeId = 16 then 2 else 0 end ,Votes.*, PostId as [Post Link] from Votes where PostId in (select Id from Posts where OwnerUserId = @UserId);