USP_DATALIST_PROGRAMSTAFFRESOURCESBYPROGRAM

Lists the program staff resources by program.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PROGRAMSTAFFRESOURCESBYPROGRAM
(
    @PROGRAMID uniqueidentifier
)
as
    set nocount on;

    select PROGRAMSTAFFRESOURCE.ID,
        PROGRAMSTAFFRESOURCE.VOLUNTEERTYPEID,
        VOLUNTEERTYPE.NAME as RESOURCENAME,
        PROGRAMSTAFFRESOURCE.QUANTITYNEEDED,
        PROGRAMSTAFFRESOURCE.FILLEDBYCODE,
        PROGRAMSTAFFRESOURCE.FILLEDBY
    from dbo.PROGRAMSTAFFRESOURCE
    inner join dbo.VOLUNTEERTYPE on 
        PROGRAMSTAFFRESOURCE.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
    where PROGRAMSTAFFRESOURCE.PROGRAMID = @PROGRAMID
    order by RESOURCENAME