spFundraiserTeamSummary

Parameters

Parameter Parameter Type Mode Description
@FundraiserId int IN

Definition

Copy


        create procedure [dbo].[spFundraiserTeamSummary]
            (@FundraiserId int)
        AS
            select 
                frt.Id,
                dbo.fnFundRaiserTeamGoal(frt.id, @FundraiserId, 3) TeamGoal,
                dbo.fnFundraiserTeamDonationTotal(frt.id, @FundraiserId, 3) TeamTotalRaised --Team Levels restricted to 3
            from 
                Fundraisers fr 
                inner join FundraiserTeams frt on fr.id = frt.RootFundraiserId
            where 
                fr.Id=@FundraiserId