UFN_RESERVATION_BUILDITINERARYITEMSSTRING

            CREATE function dbo.UFN_RESERVATION_BUILDITINERARYITEMSSTRING(@RESERVATIONID uniqueidentifier)
            returns nvarchar(max)
            with execute as caller
            as begin

                declare @ITINERARYITEMS nvarchar(max);
                declare @ITINERARYID uniqueidentifier;

                select top 1 @ITINERARYID = ID
                from dbo.ITINERARY
                where ITINERARY.RESERVATIONID = @RESERVATIONID
                order by DATEADDED;

                select top 5 @ITINERARYITEMS = coalesce(@ITINERARYITEMS + char(10), '') +
                    dbo.UFN_HOURMINUTE_DISPLAYTIME(STARTTIME) + ' ' + NAME
                from dbo.ITINERARYITEM
                where ITINERARYID = @ITINERARYID
                order by STARTDATE, STARTTIME, NAME;

                return @ITINERARYITEMS;
            end