UFN_SITEID_MAPFROM_EVENTLODGINGID

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_EVENTLODGINGID
            (  
                @EVENTLODGINGID uniqueidentifier  
            )   
            returns table
            as  
            return  
        select 
              SITEID 
        from 
              dbo.EVENTSITE
              left join dbo.EVENTLODGING on EVENTLODGING.EVENTID = EVENTSITE.EVENTID
        where 
              @EVENTLODGINGID = EVENTLODGING.ID