USP_TEAM_GETCOMPANYRAISEDTOTAL

CREATE procedure dbo.USP_TEAM_GETCOMPANYRAISEDTOTAL
(
    @ASOF datetime = null
)
as

  select TE.EVENTID as ID,
  isnull(SUM(dbo.UFN_REVENUE_GETCOMPANYRAISEDTOTAL(TFT.ID,TE.EVENTID)),0) AS VALUE
  from dbo.TEAMFUNDRAISINGTEAM TFT
  inner join dbo.TEAMEXTENSION TE
    on TE.TEAMFUNDRAISINGTEAMID = TFT.ID
  where TE.TYPECODE = 2
  GROUP BY EVENTID