UFN_TEAMFUNDRAISINGTEAMGROUP_GETGROUPGOALFOREVENTS

Returns the sum of the goals for teams that were associated with appeals on events in the given group and date range.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@GROUPID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN

Definition

Copy



            create function dbo.UFN_TEAMFUNDRAISINGTEAMGROUP_GETGROUPGOALFOREVENTS
            (
                @GROUPID uniqueidentifier=null,
                @STARTDATE datetime=null,
                @ENDDATE datetime=null
            )
            returns money
            as
            begin
                declare @GROUPGOAL money

                select @GROUPGOAL=sum(TEAMFUNDRAISINGTEAM.GOAL)
                from TEAMFUNDRAISINGTEAM
                    inner join APPEAL on APPEAL.ID = TEAMFUNDRAISINGTEAM.APPEALID
                    inner join EVENT on EVENT.APPEALID = APPEAL.ID
                where
                    TEAMFUNDRAISINGTEAM.TEAMFUNDRAISINGTEAMGROUPID=@GROUPID
                        and (APPEAL.STARTDATE >= @STARTDATE or @STARTDATE is null)   --On or after start date

                        and (APPEAL.STARTDATE <= @ENDDATE or @ENDDATE is null)   --On or before end date


                return @GROUPGOAL
            end