USP_DATALIST_RESERVATION

                CREATE procedure dbo.USP_DATALIST_RESERVATION
                as
                    set nocount on;

                    select RESERVATION.ID,
                        NAME,
                        case when ARRIVALTIME = '' then '0000' else ARRIVALTIME end STARTTIME,
                        isnull((select top 1
                                ITINERARYITEM.ENDTIME
                                from dbo.ITINERARYITEM
                                inner join dbo.ITINERARY on ITINERARY.ID = ITINERARYITEM.ITINERARYID
                                where ITINERARY.RESERVATIONID = RESERVATION.ID
                                order by ITINERARYITEM.ENDDATETIME desc
                                ), 2359) ENDTIME,
                        ARRIVALDATE as STARTDATE,
                        isnull((select top 1 ITINERARYITEM.ENDDATE
                                from dbo.ITINERARYITEM
                                inner join dbo.ITINERARY on ITINERARY.ID = ITINERARYITEM.ITINERARYID
                                where ITINERARY.RESERVATIONID = RESERVATION.ID
                                order by ENDDATE desc), ARRIVALDATE) ENDDATE
                    from dbo.RESERVATION;

                    return 0;