UFN_ITINERARYSTAFFRESOURCE_GETASSIGNMENTSTRING

Returns the names of all the staff or board members associated a given itinerary staff resource.

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYSTAFFRESOURCEID	uniqueidentifier	IN

Definition

Copy



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

                select @STAFFRESOURCES = dbo.UDA_BUILDLIST(CONSTITUENT.NAME)
                from dbo.ITINERARYSTAFFRESOURCE
                    left outer join dbo.ITINERARYSTAFFRESOURCEASSIGNMENT
                        on ITINERARYSTAFFRESOURCE.ID = ITINERARYSTAFFRESOURCEASSIGNMENT.ITINERARYSTAFFRESOURCEID
                    left outer join dbo.VOLUNTEERASSIGNMENT
                        on ITINERARYSTAFFRESOURCE.JOBOCCURRENCEID = VOLUNTEERASSIGNMENT.JOBOCCURRENCEID
                    inner join dbo.CONSTITUENT
                        on ITINERARYSTAFFRESOURCEASSIGNMENT.CONSTITUENTID = CONSTITUENT.ID or 
                            VOLUNTEERASSIGNMENT.VOLUNTEERID = CONSTITUENT.ID
                where ITINERARYSTAFFRESOURCEASSIGNMENT.ITINERARYSTAFFRESOURCEID = @ITINERARYSTAFFRESOURCEID

                return @STAFFRESOURCES;
            end