UFN_EVENTSTAFFRESOURCE_GETRESOURCES

Returns the staff resources for an event

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



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