USP_SIMPLEDATALIST_MEMBERSHIPCANCELLATIONCODE

                CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPCANCELLATIONCODE
                (
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    select
                        ID as VALUE,
                        CODE + ' - ' + DESCRIPTION as LABEL
                    from dbo.MEMBERSHIPCANCELLATIONCODE
                    where
                        @INCLUDEINACTIVE = 1 or
                        ACTIVE = 1
                    order by LABEL