USP_DATALIST_PROGRAMSTAFFRESOURCESBYRESOURCE

Lists the program resources by staff resource.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_PROGRAMSTAFFRESOURCESBYRESOURCE
            (
                @VOLUNTEERTYPEID uniqueidentifier
            )
            as
                set nocount on;

                select PROGRAMSTAFFRESOURCE.ID,
                    PROGRAMSTAFFRESOURCE.PROGRAMID,
                    PROGRAM.NAME as PROGRAMNAME,
                    PROGRAMSTAFFRESOURCE.QUANTITYNEEDED
                from dbo.PROGRAMSTAFFRESOURCE
                    inner join dbo.PROGRAM on PROGRAMSTAFFRESOURCE.PROGRAMID = PROGRAM.ID
                where PROGRAMSTAFFRESOURCE.VOLUNTEERTYPEID = @VOLUNTEERTYPEID