UFN_EVENTSTAFFRESOURCE_GETASSIGNMENTSTRING

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

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTSTAFFRESOURCEID	uniqueidentifier	IN

Definition

Copy



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

                select @STAFFRESOURCES = dbo.UDA_BUILDLIST(CONSTITUENT.NAME)
                from dbo.EVENTSTAFFRESOURCEASSIGNMENT
                    inner join dbo.CONSTITUENT
                        on EVENTSTAFFRESOURCEASSIGNMENT.CONSTITUENTID = CONSTITUENT.ID
                where EVENTSTAFFRESOURCEASSIGNMENT.EVENTSTAFFRESOURCEID = @EVENTSTAFFRESOURCEID

                return @STAFFRESOURCES;
            end