spFundRaiserTeamTopSummaries

            CREATE procedure [dbo].[spFundRaiserTeamTopSummaries]
            (@FrIds nvarchar(4000))
            as
            DECLARE @TeamRaised table(TeamID int, Raised Money)

            insert into @TeamRaised
            select frtt.frteamid, frtt.total
            from dbo.fnMakeIDsTableFromString(@FrIds, ',') ids
            cross apply [dbo].[fnFundRaiserTeamTotalDonationAmount](ids.id) frtt

            select top 10
            frt.id TeamId,
            scnt.title Fundraiser,
            frt.name TeamName,
            tr.Raised AmountRaised,
            dbo.fnFundRaiserTeamGoal(frt.ID, frt.RootFundraiserID, 3) Goal, --Team Levels restricted to 3

            dbo.fnFundRaiserTeamMemberCount(frt.ID, frt.RootFundraiserID, 3) TeamSize,--Team Levels restricted to 3

            getutcdate() As ReportTimeStamp,
            fr.ID FundraiserId
            from fundraiserteams frt
            inner join @TeamRaised tr on tr.teamid = frt.id
            inner join fundraisers fr on fr.id = frt.rootFundraiserId
            inner join sitecontent scnt on scnt.id = fr.siteContentId
            order by amountraised desc