USP_DATALIST_VOLUNTEERAWARDASSIGNMENT

List of awards that have been assigned to a specific volunteer

Parameters

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

Definition

Copy



create procedure dbo.USP_DATALIST_VOLUNTEERAWARDASSIGNMENT(@VOLUNTEERID uniqueidentifier)
as
    set nocount on;

    select ASSIGNMENT.ID,
           NAME,
           DATEAWARDED
    from dbo.VOLUNTEERAWARDASSIGNMENT ASSIGNMENT
    inner join dbo.VOLUNTEERAWARD AWARD on ASSIGNMENT.AWARDID = AWARD.ID
    where ASSIGNMENT.VOLUNTEERID = @VOLUNTEERID
    order by DATEAWARDED desc