UFN_EVENTSEATING_GETREGISTRANTSEATPATH

            create function dbo.UFN_EVENTSEATING_GETREGISTRANTSEATPATH
            (
                @REGISTRANTID uniqueidentifier
            )
            returns nvarchar(302)
            as
            begin
                declare @SECTIONNAME nvarchar(100)
                declare @SUBSECTIONNAME nvarchar(100)
                declare @SEATNAME nvarchar(100)

                declare @SEATPATH nvarchar(302)

                set @SEATPATH = '';

                if exists(select ID from dbo.EVENTSEATINGSEAT where EVENTSEATINGSEAT.REGISTRANTID = @REGISTRANTID) begin
                    select
                        @SECTIONNAME =  case when EVENTSEATING.SUBSECTIONTYPECODE = 2 then '' else cast(EVENTSEATINGSECTION.SEQUENCE as nvarchar(10)) + ' - ' + EVENTSEATINGSECTION.NAME end,
                        @SUBSECTIONNAME = cast(EVENTSEATINGSUBSECTION.SEQUENCE as nvarchar(10)) + ' - ' + EVENTSEATINGSUBSECTION.NAME,
                        @SEATNAME = cast(EVENTSEATINGSEAT.SEQUENCE as nvarchar(10)) + ' - ' + EVENTSEATINGSEAT.NAME
                    from
                        dbo.EVENTSEATINGSEAT
                        inner join dbo.EVENTSEATINGSUBSECTION on EVENTSEATINGSUBSECTION.ID = EVENTSEATINGSEAT.EVENTSEATINGSUBSECTIONID
                        inner join dbo.EVENTSEATINGSECTION on EVENTSEATINGSECTION.ID = EVENTSEATINGSUBSECTION.EVENTSEATINGSECTIONID
                        inner join dbo.EVENTSEATING on EVENTSEATING.ID = EVENTSEATINGSECTION.EVENTSEATINGID
                    where
                        EVENTSEATINGSEAT.REGISTRANTID = @REGISTRANTID;

                    if @SECTIONNAME = '' 
                        set @SEATPATH = @SUBSECTIONNAME + ' \ ' + @SEATNAME;
                    else
                        set @SEATPATH = @SECTIONNAME + ' \ ' + @SUBSECTIONNAME + ' \ ' + @SEATNAME;    
                end

                return @SEATPATH;
            end