UFN_SITEID_MAPFROM_EVENTSEATINGID

Maps a EVENTSEATINGID to a SITEID

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@EVENTSEATINGID uniqueidentifier IN

Definition

Copy


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