USP_DATALIST_EVENTSTAFFRESOURCESBYEVENT

Lists the event staff resources by event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_EVENTSTAFFRESOURCESBYEVENT
            (
                @EVENTID uniqueidentifier
            )
            as
                set nocount on;
                select EVENTSTAFFRESOURCE.ID,
                    EVENTSTAFFRESOURCE.VOLUNTEERTYPEID,
                    VOLUNTEERTYPE.NAME as RESOURCENAME,
                    EVENTSTAFFRESOURCE.QUANTITYNEEDED,
                    EVENTSTAFFRESOURCE.FILLEDBY,
                    case when EVENTSTAFFRESOURCE.FILLEDBYCODE != 0 then 
                        dbo.UFN_EVENTSTAFFRESOURCE_GETASSIGNMENTSTRING(EVENTSTAFFRESOURCE.ID) 
                    else 
                        dbo.UFN_JOBOCCURRENCE_GETASSIGNMENTSTRING(EVENTSTAFFRESOURCE.JOBOCCURRENCEID) 
                    end as ASSIGNEDRESOURCES
                from dbo.EVENTSTAFFRESOURCE
                    inner join dbo.VOLUNTEERTYPE on EVENTSTAFFRESOURCE.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
                where EVENTID = @EVENTID
                order by RESOURCENAME