UFN_ITINERARYITEMSTAFFRESOURCE_GETSTAFFRESOURCESTRING

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

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYITEMID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_ITINERARYITEMSTAFFRESOURCE_GETSTAFFRESOURCESTRING
            (
                @ITINERARYITEMID uniqueidentifier
            )
            returns nvarchar(500)
            with execute as caller
            as begin
                declare @STAFFRESOURCES nvarchar(500);

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

                return @STAFFRESOURCES
            end