You can tell it's a sql day for me today -- View image here: https://cdn.arstechnica.net/forum/smilies/biggrin.gif --<br><br>Is there any way of getting sproc like ...
select (em.fname + ' ' em.lname) as fullname, sum(case when p.eventid = 1000 then p.amount else 0 end) as 'Type1', sum(case when p.eventid = 2000 then p.amount else 0 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback