USP_TEAM_GETPARTICIPANTRAISEDTOTAL

CREATE procedure dbo.USP_TEAM_GETPARTICIPANTRAISEDTOTAL
(
    @ASOF datetime 
)
as
  select EVENT.ID,
  isnull(RESULT.VALUE,0) as VALUE
  from dbo.Event 
  left join (
    SELECT EV.ID AS ID
    ,isnull(SUM(dbo.UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL(RG.ID,EV.ID)),0) AS VALUE
    FROM REGISTRANT RG    
    inner join dbo.EVENT EV ON EV.ID = RG.EVENTID  
    inner join dbo.CONSTITUENT C ON C.ID=RG.CONSTITUENTID
    where C.ID not in (select CONSTITUENTID from dbo.TEAMFUNDRAISER where TEAMFUNDRAISER.APPEALID=EV.APPEALID)      
    GROUP BY EV.ID
  ) as Result on Result.ID = Event.ID