USP_EVENTSEATING_LAYOUTSUMMARY

            create procedure dbo.USP_EVENTSEATING_LAYOUTSUMMARY
            (
                @EVENTID uniqueidentifier
            )
            with execute as caller
            as
                select
                    EVENTSEATING.SUBSECTIONTYPECODE AS SUBSECTIONTYPECODE,
                    case SUBSECTIONTYPECODE when 0 then
                        'Table'
                    when 1 then
                        'Row'
                    else
                        'Section'
                    end as SUBSECTIONTYPETEXT,
                    EVENTSEATINGSECTION.NAME as SECTIONNAME,
                    EVENTSEATINGSUBSECTION.NAME as SUBSECTIONNAME,
                    (select count(ID) from dbo.EVENTSEATINGSEAT where EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID = EVENTSEATINGSUBSECTION.ID) as TOTALSEATCOUNT,
                    (select count(ID) from dbo.EVENTSEATINGSEAT where EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID = EVENTSEATINGSUBSECTION.ID and EVENTSEATINGSEAT.REGISTRANTID is not null) as ASSIGNEDSEATCOUNT
                from 
                    dbo.EVENTSEATING
                    inner join dbo.EVENTSEATINGSECTION ON EVENTSEATINGSECTION.EVENTSEATINGID = EVENTSEATING.ID
                    inner join dbo.EVENTSEATINGSUBSECTION ON EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID = EVENTSEATINGSECTION.ID
                where
                    EVENTSEATING.ID = @EVENTID
                order by
                    EVENTSEATINGSECTION.SEQUENCE, EVENTSEATINGSUBSECTION.SEQUENCE;