USP_TEAM_GETHOUSEHOLDRAISEDTOTAL

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

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