USP_EVENTSEATING_SEATINGSUMMARY

Returns the seating summary for a given event.
Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
Definition

Copy


            create procedure dbo.USP_EVENTSEATING_SEATINGSUMMARY
            (
                @EVENTID uniqueidentifier
            )
            with execute as caller
            as
                select
                    (select 
                        count(REGISTRANT.ID) 
                    from 
                        dbo.REGISTRANT 
                    where 
                        REGISTRANT.EVENTID = EVENT.ID and 
                        WILLNOTATTEND = 0
                    ) as TOTALREGISTRANTCOUNT,
                    (select 
                        count(EVENTSEATINGSEAT.ID)
                    from 
                        dbo.EVENTSEATINGSEAT
                        inner join dbo.EVENTSEATINGSUBSECTION on EVENTSEATINGSUBSECTION.ID = EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID
                        inner join dbo.EVENTSEATINGSECTION on EVENTSEATINGSECTION.ID = EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID            
                    where
                        EVENTSEATINGSECTION.EVENTSEATINGID = EVENT.ID
                    ) as TOTALSEATCOUNT,
                    (select 
                        count(EVENTSEATINGSEAT.ID)
                    from 
                        dbo.EVENTSEATINGSEAT
                        inner join dbo.EVENTSEATINGSUBSECTION on EVENTSEATINGSUBSECTION.ID = EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID
                        inner join dbo.EVENTSEATINGSECTION on EVENTSEATINGSECTION.ID = EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID            
                    where
                        EVENTSEATINGSECTION.EVENTSEATINGID = EVENT.ID and EVENTSEATINGSEAT.REGISTRANTID is not null
                    ) as ASSIGNEDSEATCOUNT
                from 
                    dbo.EVENT
                where
                    EVENT.ID = @EVENTID;