USP_DATALIST_MEMBERSHIPCANCELLATIONREASONCODES

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

                    select
                        ID,
                        CODE,
                        DESCRIPTION,
                        ACTIVE
                    from dbo.MEMBERSHIPCANCELLATIONCODE
                    where
                        ACTIVE = 1 or
                        @INCLUDEINACTIVE = 1
                    order by CODE asc