USP_DATALIST_ITINERARYITEM

Lists itinerary items for a given itinerary.

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_ITINERARYITEM
                (
                    @ITINERARYID uniqueidentifier
                )
                as
                set nocount on;

                    select
                        ID,
                        EVENTID,
                        PROGRAMID,
                        NAME,
                        STARTTIME,
                        ENDTIME,
                        STARTDATETIME as STARTDATE,
                        ENDDATETIME as ENDDATE,
                        NOTES,
                        ITEMTYPECODE
                    from dbo.ITINERARYITEM
                    where ITINERARYID = @ITINERARYID
                    order by STARTDATE