Have a look at my attached xls file. It provides the tables I'm referring to and the two sets of results (scroll right to see them) I'm looking to return.
I need both statement to return values based on the EventID and the number of Leads based on that EventID.
I'm really hoping someone can help me because I don't even know where to being. It is just too advanced for me.
Could someone please look at my problem and post the T-SQL statement that would return my desired result? Thanks You. I'm truly stumped.