USP_DATALIST_MEMBERSHIP_PROMOTION

                CREATE procedure dbo.USP_DATALIST_MEMBERSHIP_PROMOTION (@INCLUDEINACTIVE bit = 1)
                as
                    set nocount on;

                    select 
                        MEMBERSHIPPROMO.[ID],
                        MEMBERSHIPPROMO.[NAME],
                        MEMBERSHIPPROMO.[PROMOTIONTYPE],
                        MEMBERSHIPPROMO.[APPLICATIONTYPE],
                        MEMBERSHIPPROMO.[FORMATTEDVALUE],
                        MEMBERSHIPPROMO.[ISACTIVE],
                        MEMBERSHIPPROMO.[DESCRIPTION]
                    from dbo.MEMBERSHIPPROMO
                    where
                        @INCLUDEINACTIVE = 1 or
                        ISACTIVE = 1