UFN_SITEID_MAPFROMTRIBUTEID

            create function dbo.UFN_SITEID_MAPFROMTRIBUTEID
            (
                @TRIBUTEID uniqueidentifier
            )
            returns table 
            as
            return
            (
                select 
                    TRIBUTESITE.SITEID
                from dbo.TRIBUTE
                left join dbo.TRIBUTESITE on TRIBUTESITE.TRIBUTEID = TRIBUTE.ID --Ensure that it returns null for no site

                where TRIBUTE.ID = @TRIBUTEID
            );