USP_DATALIST_RECURRINGGIFTSTATUSREASONCODE

    CREATE procedure dbo.USP_DATALIST_RECURRINGGIFTSTATUSREASONCODE

    (
        @INCLUDEINACTIVE bit = 0
    )
    as
        set nocount on

        select
            ID,
            REASONTYPE,
            CODE,
            DESCRIPTION,
            ACTIVE
        from dbo.RECURRINGGIFTSTATUSREASONCODE
        where
            (ACTIVE = 1 or @INCLUDEINACTIVE = 1)
        order by REASONTYPE asc, CODE asc