UFN_RESERVATION_ENDDATETIME

CREATE function dbo.UFN_RESERVATION_ENDDATETIME
(
    @RESERVATIONID uniqueidentifier
)
returns datetime
as begin
    declare @ENDDATETIME datetime;

    select @ENDDATETIME = max(ITINERARYITEM.ENDDATETIME)
    from dbo.ITINERARYITEM
    inner join dbo.ITINERARY on ITINERARY.ID = ITINERARYITEM.ITINERARYID
    where ITINERARY.RESERVATIONID = @RESERVATIONID;

    if @ENDDATETIME is null
    begin
        select @ENDDATETIME = dbo.UFN_DATE_ADDHOURMINUTE(ARRIVALDATE, ARRIVALTIME)
        from dbo.RESERVATION
        where ID = @RESERVATIONID;
    end

    return @ENDDATETIME;
end