UFN_EVENTCONFLICT_GETRESOURCESTRING

Creates a string of all the resources used in an event conflict.

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTCONFLICTID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_EVENTCONFLICT_GETRESOURCESTRING
      (
        @EVENTCONFLICTID uniqueidentifier
      )
      returns nvarchar(500)
      with execute as caller
      as begin
        declare @RESOURCES nvarchar(500);

        set @RESOURCES = coalesce(stuff((select '; ' + RESOURCE.NAME + ': ' + cast(EVENTRESOURCE.QUANTITYNEEDED as nvarchar(50))
                                   from EVENTRESOURCE 
                                     inner join RESOURCE
                                       on EVENTRESOURCE.RESOURCEID = RESOURCE.ID
                                   where EVENTRESOURCE.EVENTCONFLICTID = @EVENTCONFLICTID
                                   for XML PATH('')),1, 2, ''), '')

          return @RESOURCES
      end