UFN_ITINERARYITEMSTAFFRESOURCE_GETASSIGNMENTSTRING

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

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYITEMSTAFFRESOURCEID	uniqueidentifier	IN

Definition

Copy



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

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

                return @STAFFRESOURCES;
            end