fnFundRaiserChildTeamDonationTotal

            CREATE    FUNCTION dbo.fnFundRaiserChildTeamDonationTotal(@TeamID int)
            RETURNS money
            AS
            BEGIN

            DECLARE @total1 money
            DECLARE @total2 money

            SELECT @total1=isnull(sum(d.amount),0)
            FROM 
            dbo.fnFundraiserChildTeamsforTeam(@TeamID) Team
            left join dbo.FundraiserSolicitors Solicitor on Team.TeamID = Solicitor.TeamID
            inner join dbo.FundraiserDonations d on Solicitor.ID = d.SolicitorID
            where d.IsAthon=0

            SELECT @total2=isnull(sum(d.Amount * Solicitor.AthonUnits),0)
            FROM 
            dbo.fnFundraiserChildTeamsforTeam(@TeamID) Team
            left join dbo.FundraiserSolicitors Solicitor on Team.TeamID = Solicitor.TeamID
            inner join dbo.FundraiserDonations d on Solicitor.ID = d.SolicitorID
            where d.IsAthon=1 
            and not exists(select null from dbo.FundRaiserDonations frd where frd.PledgeID=d.ID)

            RETURN @total1+@total2
            END