USP_DATALIST_ITINERARYRESOURCE

Lists all the resources associated with this 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_ITINERARYRESOURCE(@ITINERARYID uniqueidentifier)
                as
                    set nocount on;

                    select ITINERARYRESOURCE.ID,
                            ITINERARYRESOURCE.RESOURCEID,
                            RESOURCE.NAME as [RESOURCENAME],
                            CASE
                                WHEN [RESOURCE].ISPERTICKETITEM = 0 THEN CONVERT(nvarchar, ITINERARYRESOURCE.[QUANTITYNEEDED])
                                ELSE ''
                            END AS QUANTITYNEEDED,
                            CASE
                                WHEN [RESOURCE].ISPERTICKETITEM = 0 THEN ''
                                ELSE CONVERT(nvarchar, [ITINERARYRESOURCE].[PERTICKETQUANTITY])
                            END AS PERTICKETQUANTITY,
                            RESOURCE.FORMATTEDPERTICKETQUANTITY
                    from dbo.ITINERARYRESOURCE
                        inner join dbo.[RESOURCE]
                            on dbo.ITINERARYRESOURCE.RESOURCEID = RESOURCE.ID
                    where ITINERARYRESOURCE.ITINERARYID = @ITINERARYID