UFN_JOBOCCURRENCE_GETASSIGNMENTSTRING

Creates a string of all the volunteers assigned to the job occurrence.

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@JOBOCCURRENCEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_JOBOCCURRENCE_GETASSIGNMENTSTRING
            (
                @JOBOCCURRENCEID uniqueidentifier
            )
            returns nvarchar(500)
            with execute as caller
            as begin
                declare @VOLUNTEERS nvarchar(500);

                select @VOLUNTEERS = left(dbo.UDA_BUILDLIST(CONSTITUENT.NAME), 500)
                from VOLUNTEERASSIGNMENT 
                    inner join CONSTITUENT on VOLUNTEERASSIGNMENT.VOLUNTEERID = CONSTITUENT.ID
                where VOLUNTEERASSIGNMENT.JOBOCCURRENCEID = @JOBOCCURRENCEID

                return @VOLUNTEERS
            end