UFN_SITEID_MAPFROM_GROUPMEMBERID

           create function dbo.UFN_SITEID_MAPFROM_GROUPMEMBERID  
           (  
            @GROUPMEMBERID uniqueidentifier  
           )   
           returns table
           as  
            return
                (
                select CONSTITUENTSITE.SITEID
                from dbo.CONSTITUENT with (nolock)
                inner join dbo.GROUPMEMBER with (nolock)
                    on GROUPMEMBER.MEMBERID = CONSTITUENT.ID
                left outer join dbo.CONSTITUENTSITE with (nolock)
                    on CONSTITUENT.ID = CONSTITUENTSITE.CONSTITUENTID
                where GROUPMEMBER.ID = @GROUPMEMBERID
                )