UFN_TRACKITEMSTAFFRESOURCE_GETSTAFFRESOURCESTRING

Creates a string of all the staff resources used in an track item.

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@TRACKITEMID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_TRACKITEMSTAFFRESOURCE_GETSTAFFRESOURCESTRING
            (
                @TRACKITEMID uniqueidentifier
            )
            returns nvarchar(500)
            with execute as caller
            as begin
                declare @STAFFRESOURCES nvarchar(500);

                set @STAFFRESOURCES = stuff((select '; ' + VOLUNTEERTYPE.NAME + ': ' + cast(TRACKITEMSTAFFRESOURCE.QUANTITYNEEDED as nvarchar(50))
                from TRACKITEMSTAFFRESOURCE 
                    inner join VOLUNTEERTYPE
                        on TRACKITEMSTAFFRESOURCE.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
                where TRACKITEMSTAFFRESOURCE.TRACKITEMID = @TRACKITEMID
                for XML PATH('')),1, 2, '')

                return @STAFFRESOURCES
            end