UFN_ITINERARYSTAFFRESOURCE_GETSTAFFRESOURCESTRING

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

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYID	uniqueidentifier	IN

Definition

Copy



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

                select @STAFFRESOURCES = dbo.UDA_BUILDLIST(VOLUNTEERTYPE.NAME + ': ' + cast(ITINERARYSTAFFRESOURCE.QUANTITYNEEDED as nvarchar(50)))
                from ITINERARYSTAFFRESOURCE 
                    inner join VOLUNTEERTYPE
                    on ITINERARYSTAFFRESOURCE.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
                where ITINERARYSTAFFRESOURCE.ITINERARYID = @ITINERARYID

                return @STAFFRESOURCES
            end