USP_SIMPLEDATALIST_RECURRINGGIFTINSTALLMENTSKIPREASONCODES

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

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