UFN_TEAMFUNDRAISINGTEAMGROUP_GETLATESTTEAMONEVENT

Returns the ID of the team associated with the most recent appeal on an event in the given group and date range.

Return

Return Type
uniqueidentifier

Parameters

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

Definition

Copy



            create function dbo.UFN_TEAMFUNDRAISINGTEAMGROUP_GETLATESTTEAMONEVENT
            (
                @GROUPID uniqueidentifier=null,
                @STARTDATE datetime=null,
                @ENDDATE datetime=null
            )
            returns uniqueidentifier
            as
            begin
                declare @TEAMID uniqueidentifier

                select top 1 @TEAMID=TEAMFUNDRAISINGTEAM.ID
                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

                order by APPEAL.STARTDATE desc

                return @TEAMID
            end