Q&A for people looking to bypass life's everyday problems with simple tricks
DECLARE @UserId int = ##UserId## -- Enter Query Title -- Enter Query Description --select * from VoteTypes; --select * from PostTypes; select Id, sum(Score) from (select UserId as Id, Score from Comments --where Userid is not null where Userid = @UserId union all select OwnerUserId as Id, Score from Posts --where OwnerUserId is not null where OwnerUserId = @UserId ) as w group by Id;