UFN_EVENTCONFLICT_GETSTAFFRESOURCESTRING

Creates a string of all the staff 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_GETSTAFFRESOURCESTRING
            (
                @EVENTCONFLICTID uniqueidentifier
            )
            returns nvarchar(500)
            with execute as caller
            as begin
                declare @STAFFRESOURCES nvarchar(500);

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

                return @STAFFRESOURCES;
            end