USP_SIMPLEDATALIST_RECURRINGGIFTSTATUSREASONCODE

create procedure dbo.USP_SIMPLEDATALIST_RECURRINGGIFTSTATUSREASONCODE (
    @TYPE tinyint = 0
)
    as
    set nocount on;

    select 
        ID as VALUE, 
        CODE + ' - ' + DESCRIPTION as LABEL
    from dbo.RECURRINGGIFTSTATUSREASONCODE
    where REASONTYPECODE = @TYPE and ACTIVE = 1
    order by DESCRIPTION