USP_TEAM_GETTEAMRAISEDTOTAL

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

  select TE.EVENTID as ID,
  isnull(SUM(dbo.UFN_REVENUE_GETTEAMRAISEDTOTAL(TFT.ID,TE.EVENTID)),0) AS VALUE
  from dbo.TEAMFUNDRAISINGTEAM TFT
  inner join dbo.TEAMEXTENSION TE
    on TE.TEAMFUNDRAISINGTEAMID = TFT.ID
  where TE.TYPECODE = 1
        and TFT.PARENTTEAMID is null
  GROUP BY EVENTID