UFN_EVENTSTAFFRESOURCE_GETSTAFFRESOURCESTRING

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

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



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

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

                return @STAFFRESOURCES;
            end