UFN_EVENTSEATING_GETALLSEATS

            CREATE function dbo.UFN_EVENTSEATING_GETALLSEATS
            (
                @EVENTSEATINGID uniqueidentifier = null                
            ) 
            returns xml
            as
            begin
            return
            ( 
                select 
                    EVENTSEATINGSEAT.ID, 
                    EVENTSEATINGSEAT.SEQUENCE, 
                    EVENTSEATINGSEAT.NAME, 
                    EVENTSEATINGSEAT.REGISTRANTID,
                    EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID,
                    dbo.UFN_REGISTRANT_GETNAME(REGISTRANT.ID) [REGISTRANTNAME]
                from 
                    dbo.EVENTSEATINGSEAT
                    inner join dbo.EVENTSEATINGSUBSECTION on EVENTSEATINGSUBSECTION.ID = EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID
                    inner join dbo.EVENTSEATINGSECTION on EVENTSEATINGSECTION.ID = EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID
                    left join dbo.REGISTRANT on REGISTRANT.ID = EVENTSEATINGSEAT.REGISTRANTID
                where
                    EVENTSEATINGSECTION.EVENTSEATINGID = @EVENTSEATINGID
                order by 
                    EVENTSEATINGSEAT.SEQUENCE
                for xml raw('ITEM'),type,elements,root('SEATS'),BINARY BASE64
            )
            end