UFN_ITINERARYITEMRESOURCE_GETRESOURCESTRING

Returns a user displayable string of the resources used by an itinerary item.

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYITEMID	uniqueidentifier	IN

Definition

Copy



      CREATE function dbo.UFN_ITINERARYITEMRESOURCE_GETRESOURCESTRING
        (@ITINERARYITEMID uniqueidentifier)
      returns nvarchar(500)
      with execute as caller
      as begin
        declare @RESOURCES nvarchar(500);

        set @RESOURCES = coalesce(stuff((select '; ' + RESOURCE.NAME + ': '
                                        + case when RESOURCE.ISPERTICKETITEM <> 1 then cast(ITINERARYITEMRESOURCE.QUANTITYNEEDED as nvarchar(50))
                                            when RESOURCE.PERTICKETDIVISOR > 1 then RESOURCE.FORMATTEDPERTICKETQUANTITY
                                            else cast(ITINERARYITEMRESOURCE.PERTICKETQUANTITY as nvarchar(50))  + ' per ticket'
                                        end
                                   from ITINERARYITEMRESOURCE 
                                     inner join RESOURCE
                                       on ITINERARYITEMRESOURCE.RESOURCEID = RESOURCE.ID
                                   where ITINERARYITEMRESOURCE.ITINERARYITEMID = @ITINERARYITEMID
                                   for XML PATH('')),1, 2, ''), '')

          return @RESOURCES;
      end