UFN_SITEID_MAPFROM_EVENTGROUPMEMBERID

            create function dbo.UFN_SITEID_MAPFROM_EVENTGROUPMEMBERID  
            (  
            @EVENTGROUPMEMBERID uniqueidentifier  
            )   
            returns table
            as  
            return
                select EVENTSITE.SITEID   
                from dbo.EVENTGROUPMEMBER  
                left outer join dbo.EVENTGROUP on EVENTGROUP.ID = EVENTGROUPMEMBER.EVENTGROUPID  
                left outer join dbo.EVENTSITE on EVENTSITE.EVENTID = EVENTGROUP.EVENTID  
                where EVENTGROUPMEMBER.ID = @EVENTGROUPMEMBERID;