UFN_PROGRAM_GETSEQUENCEDLOCATIONS

Retrieves locations for a program along with their sequences.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



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