UFN_SITEID_MAPFROM_TEAMFUNDRAISINGTEAMCAPTAINID

            create function dbo.UFN_SITEID_MAPFROM_TEAMFUNDRAISINGTEAMCAPTAINID
            (
                @TEAMFUNDRAISINGTEAMCAPTAINID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select
                    @ID = [APPEAL].[SITEID]
                from
                    dbo.TEAMFUNDRAISINGTEAMCAPTAIN
                    inner join dbo.TEAMFUNDRAISINGTEAM on [TEAMFUNDRAISINGTEAMCAPTAIN].[TEAMFUNDRAISINGTEAMID] = [TEAMFUNDRAISINGTEAM].[ID]
                    inner join dbo.APPEAL on [TEAMFUNDRAISINGTEAM].[APPEALID] = [APPEAL].[ID]
                where
                    [TEAMFUNDRAISINGTEAMCAPTAIN].[ID] = @TEAMFUNDRAISINGTEAMCAPTAINID;

                return @ID;
            end