UFN_SITEID_MAPFROM_FAFTEAMFUNDRAISINGTEAMID

            create function dbo.UFN_SITEID_MAPFROM_FAFTEAMFUNDRAISINGTEAMID
            (
                @TEAMFUNDRAISINGTEAMID uniqueidentifier
            )
            returns table
            as
            return
                select
                    EVENTSITE.SITEID
                from
                    dbo.TEAMFUNDRAISINGTEAM TFT
                    join dbo.TEAMEXTENSION TX on TFT.ID = TX.TEAMFUNDRAISINGTEAMID
          left outer join dbo.EVENTSITE on EVENTSITE.EVENTID = TX.EVENTID
                where
                    TFT.ID = @TEAMFUNDRAISINGTEAMID;