USP_TEAM_GETFUNDRAISINGGROUPRAISEDTOTAL

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

  select TFT.ID,
  isnull(Sum(CASE WHEN TE.TYPECODE=1 THEN  dbo.UFN_REVENUE_GETTEAMRAISEDTOTAL(TFT.ID,TE.EVENTID)
  WHEN TE.TYPECODE=2 THEN  dbo.UFN_REVENUE_GETCOMPANYRAISEDTOTAL(TFT.ID,TE.EVENTID)
  WHEN TE.TYPECODE=3 THEN  dbo.UFN_REVENUE_GETHOUSEHOLDRAISEDTOTAL(TFT.ID,TE.EVENTID)
  END),0) AS VALUE
  from dbo.TEAMFUNDRAISINGTEAM TFT
  inner join dbo.TEAMEXTENSION TE
    on TE.TEAMFUNDRAISINGTEAMID = TFT.ID
  group by TFT.ID