UFN_TRACKRESOURCE_GETRESOURCESTRING

Creates a string of all the resources used in a track.

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@TRACKID	uniqueidentifier	IN

Definition

Copy



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

        set @RESOURCES = stuff((select '; ' + RESOURCE.NAME + ': '
                                        + CASE WHEN RESOURCE.ISPERTICKETITEM <> 1 THEN cast(TRACKRESOURCE.QUANTITYNEEDED as nvarchar(50))
                                            ELSE cast(RESOURCE.PERTICKETQUANTITY as nvarchar(50))  + ' per ticket'
                                        END
                                   from TRACKRESOURCE 
                                     inner join RESOURCE
                                       on TRACKRESOURCE.RESOURCEID = RESOURCE.ID
                                   where TRACKRESOURCE.TRACKID = @TRACKID
                                   for XML PATH('')),1, 2, '')

          return @RESOURCES
      end