UFN_EVENTSEATINGSUBSECTION_GETSEATS

Returns all seats for a given event seating sub-section.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTSEATINGSUBSECTIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENTSEATINGSUBSECTION_GETSEATS(@EVENTSEATINGSUBSECTIONID uniqueidentifier)
            returns table
            as
            return
            (
                select 
                    EVENTSEATINGSEAT.ID, 
                    EVENTSEATINGSEAT.NAME, 
                    EVENTSEATINGSEAT.REGISTRANTID, 
                    EVENTSEATINGSEAT.SEQUENCE
                from 
                    dbo.EVENTSEATINGSEAT
                where 
                    EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID = @EVENTSEATINGSUBSECTIONID
            )