UFN_ITINERARYRESOURCE_GETRESOURCES

        CREATE function dbo.UFN_ITINERARYRESOURCE_GETRESOURCES
        (
          @ITINERARYID uniqueidentifier
        )
        returns table
        as return
            select ITINERARYRESOURCE.ID AS ID,
                ITINERARYRESOURCE.RESOURCEID,
                ITINERARYRESOURCE.QUANTITYNEEDED,
                RESOURCE.ISPERTICKETITEM,
                RESOURCE.NAME as RESOURCENAME,
                ITINERARYRESOURCE.PERTICKETQUANTITY,
                ITINERARYRESOURCE.PRICE,
                ITINERARYRESOURCE.PRICINGSTRUCTURECODE,
                case when (GROUPTYPEREQUIREDRESOURCE.ID is null) then 0 else 1 end as ISREQUIREDRESOURCE,
                coalesce(GROUPTYPEREQUIREDRESOURCE.QUANTITYNEEDED, 0) as REQUIREDRESOURCEQUANTITY,
                ITINERARYRESOURCE.PERTICKETDIVISOR
            from ITINERARYRESOURCE
                inner join RESOURCE
                    on ITINERARYRESOURCE.RESOURCEID = RESOURCE.ID
                inner join dbo.ITINERARY
                    on ITINERARYRESOURCE.ITINERARYID = ITINERARY.ID
                left outer join dbo.GROUPTYPEREQUIREDRESOURCE
                    on (ITINERARYRESOURCE.RESOURCEID = GROUPTYPEREQUIREDRESOURCE.RESOURCEID) and
                        (ITINERARY.GROUPSALESGROUPTYPECODEID = GROUPTYPEREQUIREDRESOURCE.GROUPSALESGROUPTYPECODEID)
            where ITINERARYRESOURCE.ITINERARYID = @ITINERARYID