vwFundraiserSummaries

Fields

Field	Field Type	Null
Id	int
Name	nvarchar(256)	yes
AmountRaised	money	yes
Goal	money	yes
DonationCount	int	yes
Participants	int	yes
Teams	int	yes

Definition

Copy



            Create View [dbo].[vwFundraiserSummaries]

                as

            select 

                fr.id Id,

                scnt.title [Name],

                dbo.fnFundraiserDonationTotal(fr.id) AmountRaised,

                dbo.fnFundraiserGoal(fr.id) Goal,

                dbo.fnFundraiserDonationCount(fr.id) DonationCount,   

                dbo.fnFundRaiserSolicitorCount(fr.id) Participants,

                dbo.fnFundRaiserTeamCount(fr.id) Teams

            from

            dbo.fundraisers fr 

            inner join dbo.sitecontent scnt on fr.sitecontentid = scnt.id