UFN_EVENTSEATING_GETALLSUBSECTIONS

Returns all sub-sections for a given event seating layout.
Return

Return Type
xml
Parameters

Parameter	Parameter Type	Mode	Description
@EVENTSEATINGID	uniqueidentifier	IN
Definition

Copy


            create function dbo.UFN_EVENTSEATING_GETALLSUBSECTIONS
            (
                @EVENTSEATINGID uniqueidentifier = null                
            ) 
            returns xml
            as
            begin
            return
            ( 
                select 
                    EVENTSEATINGSUBSECTION.ID, 
                    EVENTSEATINGSUBSECTION.SEQUENCE, 
                    EVENTSEATINGSUBSECTION.NAME, 
                    EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID,
                    (select count(ID) from dbo.EVENTSEATINGSEAT where EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID = EVENTSEATINGSUBSECTION.ID) as NUMBEROFSEATS,
                    (select min(SEQUENCE) from dbo.EVENTSEATINGSEAT where EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID = EVENTSEATINGSUBSECTION.ID) as STARTINGSEATNUMBER,
                    (select max(SEQUENCE) from dbo.EVENTSEATINGSEAT where EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID = EVENTSEATINGSUBSECTION.ID) as ENDINGSEATNUMBER
                from 
                    dbo.EVENTSEATINGSUBSECTION
                    inner join dbo.EVENTSEATINGSECTION on EVENTSEATINGSECTION.ID = EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID
                where
                    EVENTSEATINGSECTION.EVENTSEATINGID = @EVENTSEATINGID
                order by
                    EVENTSEATINGSUBSECTION.SEQUENCE
                for xml raw('ITEM'),type,elements,root('SUBSECTIONS'),BINARY BASE64
            )
            end