USP_DATALIST_TEAMFUNDRAISINGTEAM_HISTORY

This data list returns a list of team fundraising teams that are in the same history group.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_TEAMFUNDRAISINGTEAM_HISTORY(@ID uniqueidentifier)
            as
                set nocount on;

                select
                    [TEAMHISTORY].TEAMFUNDRAISINGTEAMGROUPID,
                    [TEAMHISTORY].ID [TEAMFUNDRAISINGTEAMID],
                    [TEAMHISTORY].NAME [TEAMFUNDRAISINGTEAMNAME],
                    [TEAMHISTORY].GOAL [TEAMFUNDRAISINGTEAMGOAL],
                    [TEAMHISTORY].APPEALID,
                    APPEAL.NAME [APPEALNAME],
                    EVENT.ID [EVENTID],
                    EVENT.NAME [EVENTNAME]
                from
                    dbo.TEAMFUNDRAISINGTEAM
                    left join dbo.TEAMFUNDRAISINGTEAM [TEAMHISTORY] on
                        TEAMFUNDRAISINGTEAM.TEAMFUNDRAISINGTEAMGROUPID = [TEAMHISTORY].TEAMFUNDRAISINGTEAMGROUPID
                        or TEAMFUNDRAISINGTEAM.ID = [TEAMHISTORY].ID
                    left join dbo.EVENT on [TEAMHISTORY].APPEALID = EVENT.APPEALID
                    left join dbo.APPEAL on [TEAMHISTORY].APPEALID = APPEAL.ID
                where
                    TEAMFUNDRAISINGTEAM.ID = @ID
                    and [TEAMHISTORY].ID is not null
                order by
                    case when [TEAMHISTORY].ID = @ID then 0 else 1 end,
                    APPEAL.STARTDATE desc;