USP_SIMPLEDATALIST_VOLUNTEERAWARD

List of awards that can be assigned to a volunteer

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN
@EXISTINGID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_VOLUNTEERAWARD
(
    @INCLUDEINACTIVE bit = 0,
    @EXISTINGID uniqueidentifier = null
)
as
    select 
        ID as VALUE, 
        NAME as LABEL
    from dbo.VOLUNTEERAWARD
    where (@INCLUDEINACTIVE = 1) or (ISACTIVE = 1) or (ID = @EXISTINGID)
    order by NAME asc