UFN_SITEID_MAPFROM_EVENTLODGINGROOMID

      create function dbo.UFN_SITEID_MAPFROM_EVENTLODGINGROOMID
            (  
                @EVENTLODGINGROOMID uniqueidentifier  
            )   
            returns table
            as  
            return  
                select 
                    EVENTSITE.SITEID   
        from 
              dbo.EVENTSITE
              left join dbo.EVENTLODGING on EVENTLODGING.EVENTID = EVENTSITE.EVENTID
              left join dbo.EVENTLODGINGROOM on EVENTLODGINGROOM.EVENTLODGINGID = EVENTLODGING.ID
        where 
              @EVENTLODGINGROOMID = EVENTLODGINGROOM.ID