UFN_EVENT_GETSEQUENCEDLOCATIONS

Retrieves locations for an event along with their sequences.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENT_GETSEQUENCEDLOCATIONS(@EVENTID uniqueidentifier)
            returns table
            as return
                select
                    PROGRAMEVENTLOCATION.ID,
                    PROGRAMEVENTLOCATION.EVENTLOCATIONID,
                    EVENTLOCATION.CAPACITY,
                    PROGRAMEVENTLOCATION.SEQUENCE
                from
                    dbo.PROGRAMEVENTLOCATION
                inner join 
                    dbo.EVENTLOCATION on PROGRAMEVENTLOCATION.EVENTLOCATIONID = EVENTLOCATION.ID
                where
                    PROGRAMEVENTLOCATION.EVENTID = @EVENTID;