UFN_SITEID_MAPFROM_EVENTID

Maps a EVENTID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_EVENTID  
            (  
            @EVENTID uniqueidentifier  
            )   
            returns table
            as  
            return
                select EVENTSITE.SITEID
                from dbo.[EVENT]
                left outer join dbo.EVENTSITE on EVENTSITE.EVENTID = [EVENT].ID
                where [EVENT].ID = @EVENTID;