USP_DATALIST_ITINERARY

Lists all itineraries for a reservation.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_ITINERARY(@CONTEXTID uniqueidentifier)
            as
                set nocount on;

                select 
                    ID,
                    left(NAME,90),
                    dbo.UFN_CONSTITUENT_BUILDNAME(LEADERID),
                    coalesce(
                        (
                            select sum(QUANTITY) from dbo.ITINERARYATTENDEE 
                            where ITINERARYID = ITINERARY.ID
                        ), 0
                    ) as NUMBEROFVISITORS,
                    dbo.UFN_HOURMINUTE_GETFROMDATE(ITINERARY.STARTDATETIME) as STARTDATETIME,
                    dbo.UFN_HOURMINUTE_GETFROMDATE(ITINERARY.ENDDATETIME) as ENDDATETIME,
                    dbo.UFN_GROUPSALESGROUPTYPECODE_GETDESCRIPTION(ITINERARY.GROUPSALESGROUPTYPECODEID) as GROUPTYPE
                from dbo.ITINERARY
                where 
                    RESERVATIONID = @CONTEXTID