UFN_SITEID_MAPFROM_APPEALIDTEAMFUNDRAISINGTEAMID

Maps an APPEALID and a TEAMFUNDRAISINGTEAMID to a SITEID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALIDTEAMFUNDRAISINGTEAMID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_APPEALIDTEAMFUNDRAISINGTEAMID
            (
                @APPEALIDTEAMFUNDRAISINGTEAMID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select
                    @ID = [APPEAL].[SITEID]
                from
                    dbo.APPEAL
                where
                    [APPEAL].[ID] = left(@APPEALIDTEAMFUNDRAISINGTEAMID, 36);

                return @ID;
            end