spFinancialValidationReport

            CREATE procedure [dbo].[spFinancialValidationReport]
                (@FundraiserId int)
            AS
                select 
                    usr.LastName, 
                    usr.FirstName, 
                    isnull(frt.Name, '') Team, 
                    dbo.fnFundraiserSolicitorDonationTotal(frs.id) TotalRaised
                from 
                    dbo.fundraiserSolicitors frs
                    inner join dbo.fundraisers fr on fr.id = frs.rootFundraiserId
                    inner join dbo.clientusers usr on frs.ClientUsersId=usr.id 
                    left join dbo.fundraiserTeams frt on frs.teamid = frt.id
                where 
                    frs.rootFundraiserId = @FundraiserId
                    AND usr.Deleted = 0
                order by 
                    LastName, FirstName