UFN_ITINERARYITEMRESOURCE_GETRESOURCES

Returns the resources for an itinerary item

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYITEMID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_ITINERARYITEMRESOURCE_GETRESOURCES
        (
          @ITINERARYITEMID uniqueidentifier
        )
        returns table
        as return
            select ITINERARYITEMRESOURCE.ID AS ID,
                         ITINERARYITEMRESOURCE.RESOURCEID,
                         ITINERARYITEMRESOURCE.QUANTITYNEEDED,
                         RESOURCE.ISPERTICKETITEM,
                         ITINERARYITEMRESOURCE.PERTICKETQUANTITY,
                         ITINERARYITEMRESOURCE.PRICE,
                         ITINERARYITEMRESOURCE.PRICINGSTRUCTURECODE,
                         ITINERARYITEMRESOURCE.PERTICKETDIVISOR
            from ITINERARYITEMRESOURCE
                inner join RESOURCE on ITINERARYITEMRESOURCE.RESOURCEID = RESOURCE.ID
            where ITINERARYITEMRESOURCE.ITINERARYITEMID = @ITINERARYITEMID