UFN_SITEID_MAPFROM_EVENTLODGINGLOCATIONID

Maps a EVENTLODGINGID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTLODGINGID	uniqueidentifier	IN

Definition

Copy



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