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