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