UFN_ITINERARY_GETITINERARYITEMSINFO

Retrieves the information for items on an itinerary

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_ITINERARY_GETITINERARYITEMSINFO
        (
            @ITINERARYID uniqueidentifier
        )
        returns table
        as return
            select
                ID,
                NAME,
                STARTTIME,
                ENDTIME,
                STARTDATE,
                ENDDATE,
                ITEMTYPECODE
            from
                dbo.ITINERARYITEM
            where
                ITINERARYID=@ITINERARYID;