UFN_EVENTCONFLICT_GETSTAFFRESOURCES

Returns the staff resources for an event conflict

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTCONFLICTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENTCONFLICT_GETSTAFFRESOURCES
            (
                @EVENTCONFLICTID uniqueidentifier
            )
          returns table
          as return
              select EVENTSTAFFRESOURCE.ID AS ID,
                           EVENTSTAFFRESOURCE.VOLUNTEERTYPEID,
                           EVENTSTAFFRESOURCE.QUANTITYNEEDED,
                           EVENTSTAFFRESOURCE.FILLEDBYCODE
              from EVENTSTAFFRESOURCE
              where EVENTSTAFFRESOURCE.EVENTCONFLICTID = @EVENTCONFLICTID