USP_TEAM_GETNUMBEROFDONOR

CREATE procedure dbo.USP_TEAM_GETNUMBEROFDONOR
(
    @ASOF datetime = null 
)
as
  select EV.ID 
  ,COUNT(R.CONSTITUENTID) AS VALUE 
  from dbo.REVENUE R
  inner join dbo.REVENUESPLIT RS ON R.ID = RS.REVENUEID
  inner join dbo.EVENT EV ON EV.APPEALID=R.APPEALID 
  where (R.TRANSACTIONTYPECODE = 0 and RS.APPLICATIONCODE = 1)
  OR (R.TRANSACTIONTYPECODE in (1,2) and RS.APPLICATIONCODE = 0) --pledge or recurring gift

  GROUP BY EV.ID