vwFundRaiserTeamSummaries

Fields

Field	Field Type	Null
FundraiserId	int	yes
Fundraiser	nvarchar(256)	yes
TeamId	int
TeamName	nvarchar(100)	yes
AmountRaised	money	yes
Goal	money	yes
TeamSize	int	yes

Definition

Copy



            CREATE view [dbo].[vwFundRaiserTeamSummaries]
            as
                select
                    frt.RootFundraiserId FundraiserId,
                    scnt.title Fundraiser, 
                    frt.id TeamId, 
                    frt.name TeamName, 
                    dbo.fnFundraiserTeamDonationTotal(frt.id, fr.id, 3) AmountRaised, --Team Levels restricted to 3
                    dbo.fnFundRaiserTeamGoal(frt.id, fr.id, 3) Goal, --Team Levels restricted to 3
                    dbo.fnFundRaiserTeamMemberCount(frt.id, fr.id, 3) TeamSize --Team Levels restricted to 3
                from fundraiserTeams frt
                        inner join fundraisers fr on fr.id = frt.rootFundraiserId
                        inner join sitecontent scnt on scnt.id = fr.siteContentId