UFN_ITINERARY_ENDDATETIME

Returns the end date and time of a given itinerary.

Return

Return Type
datetime

Parameters

Parameter Parameter Type Mode Description
@ITINERARYID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_ITINERARY_ENDDATETIME
(
    @ITINERARYID uniqueidentifier
)
returns datetime
with execute as caller
as begin
    declare @END datetime;

    select @END = max(ENDDATETIME)
    from dbo.ITINERARYITEM
    where ITINERARYID = @ITINERARYID;

    return @END;
end