UFN_EVENTSEATING_GETSECTIONS

Returns all sections for a given event seating layout.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTSEATINGID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENTSEATING_GETSECTIONS(@EVENTSEATINGID uniqueidentifier)
            returns table
            as
            return
            (
                select 
                    ID, 
                    SEQUENCE, 
                    NAME, 
                    (select count(ID) from dbo.EVENTSEATINGSUBSECTION where EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID = EVENTSEATINGSECTION.ID) as NUMBEROFSUBSECTIONS,
                    (select min(SEQUENCE) from dbo.EVENTSEATINGSUBSECTION where EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID = EVENTSEATINGSECTION.ID) as STARTINGSUBSECTIONNUMBER,
                    (select max(SEQUENCE) from dbo.EVENTSEATINGSUBSECTION where EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID = EVENTSEATINGSECTION.ID) as ENDINGSUBSECTIONNUMBER
                from 
                    dbo.EVENTSEATINGSECTION
                where 
                    EVENTSEATINGSECTION.EVENTSEATINGID = @EVENTSEATINGID
            )