fnFundRaiserTeamGoal

        CREATE function [dbo].[fnFundRaiserTeamGoal](   

               @FundRaiserTeamID int,
               @RootFundraiserID int,
               @Depth int)

            returns money
            as

            begin

                Declare @AggregateGoal money

                SELECT
                    @AggregateGoal = isnull(sum(frs.goal),0)

                FROM
                    dbo.fnFundRaiserTeamSolicitors(@FundRaiserTeamID, @RootFundRaiserID, @Depth) solicitor
                    inner join dbo.FundRaiserSolicitors frs on frs.id = solicitor.SolicitorID

                return @AggregateGoal

            end