UFN_SITEID_MAPFROM_EVENTSPEAKERID

Maps a EVENTSPEAKERID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTSPEAKERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_EVENTSPEAKERID  
            (  
                @EVENTSPEAKERID uniqueidentifier  
            )   
            returns table
            as  
            return  
                select 
                    EVENTSITE.SITEID   
                from 
                    dbo.EVENTSPEAKER
                    left outer join dbo.EVENTSITE on EVENTSPEAKER.EVENTID = EVENTSITE.EVENTID  
                where 
                    EVENTSPEAKER.ID = @EVENTSPEAKERID;