USP_DATALIST_VOLUNTEERAWARD

CREATE procedure dbo.USP_DATALIST_VOLUNTEERAWARD
(
    @INCLUDEINACTIVE bit = 0
)
as
    set nocount on;

    select AWARD.ID,
           NAME,
           CODE.DESCRIPTION as TYPE,
           AWARD.DESCRIPTION,
           AWARD.ISACTIVE
    from dbo.VOLUNTEERAWARD AWARD
    inner join dbo.VOLUNTEERAWARDTYPECODE CODE
    on AWARD.VOLUNTEERAWARDTYPECODEID = CODE.ID
    where (@INCLUDEINACTIVE = 1) or (ISACTIVE = 1)