USP_DATALIST_FAFREGISTRATIONOPTION_PERFORMANCE

CREATE procedure dbo.USP_DATALIST_FAFREGISTRATIONOPTION_PERFORMANCE(@EVENTID uniqueidentifier)
as
    set nocount on;

  select EP.ID
    ,EP.NAME
    ,ISNULL(sum(RR.QUANTITY), 0) as [REGISTRANTCOUNT]
    ,ISNULL(sum(RR.AMOUNT), 0) as [REGISTRATIONFEE]
    ,count(RD.ID) as [VOLUNTARYDONATIONCOUNT]
    ,ISNULL(sum(RD.VOLUNTARYDONATION), 0) as [VOLUNTARYDONATION]
    ,EP.AMOUNT
  from dbo.EVENTPRICE EP(nolock)
  left outer join dbo.REGISTRANTREGISTRATION RR(nolock)
      on EP.ID = RR.EVENTPRICEID
  left outer join dbo.REGISTRANTDONATION RD(nolock)
      on RR.REGISTRANTID = RD.REGISTRANTID and RD.VOLUNTARYDONATION > 0
  where EP.EVENTID = @EVENTID
  group by EP.ID, EP.NAME, EP.AMOUNT
  --order by EP.AMOUNT, EP.NAME 


  Union

 Select NEWID(), 'No Reg Option' As Name, count(*) As REGISTRANTCOUNT, sum(rs.amount) As RegistrationFee,
     0 As VOLUNTARYDONATIONCOUNT, 0 as VOLUNTARYDONATION, sum(rs.amount) As Amount
     from dbo.REVENUESPLIT rs 
         Inner Join REVENUE rv on rv.ID = rs.REVENUEID
         Inner Join EVENT e on e.APPEALID = rv.APPEALID
    where rs.TYPE ='Event registration'
        and e.ID = @EVENTID
        and rv.CONSTITUENTID not in (select CONSTITUENTID from REGISTRANT where EVENTID = @EVENTID)
    group by rs.Type

 Order by Name