UFN_SITEID_MAPFROM_EVENTIDTEAMFUNDRAISINGTEAMID

Maps an EVENTID and a TEAMFUNDRAISINGTEAMID to a SITEID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTIDTEAMFUNDRAISINGTEAMID	nvarchar(72)	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_EVENTIDTEAMFUNDRAISINGTEAMID
            (
                @EVENTIDTEAMFUNDRAISINGTEAMID nvarchar(72)
            )
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select
                    @ID = [APPEAL].[SITEID]
                from
                    dbo.TEAMFUNDRAISINGTEAM
                    inner join dbo.APPEAL on [TEAMFUNDRAISINGTEAM].[APPEALID] = [APPEAL].[ID]
                where
                    [TEAMFUNDRAISINGTEAM].[ID] = right(@EVENTIDTEAMFUNDRAISINGTEAMID, 36);

                return @ID;
            end