USP_DATALIST_MEMBERSHIP_PROMOTIONFORCLR

        create procedure dbo.USP_DATALIST_MEMBERSHIP_PROMOTIONFORCLR (@INCLUDEINACTIVE bit = 1)
        as
        begin
                set nocount on;

                            select 
                                MEMBERSHIPPROMO.[ID],
                                MEMBERSHIPPROMO.[NAME],
                                MEMBERSHIPPROMO.[PROMOTIONTYPE],
                                MEMBERSHIPPROMO.[APPLICATIONTYPE],
                    MEMBERSHIPPROMO.[EXTENSIONCALCULATIONTYPECODE],
                                MEMBERSHIPPROMO.[ISACTIVE],
                                MEMBERSHIPPROMO.[DESCRIPTION],
                    MEMBERSHIPPROMO.[DISCOUNTCALCULATIONTYPECODE],
                    MEMBERSHIPPROMO.[APPLICATIONTYPECODE],
                    MEMBERSHIPPROMO.[PERCENT],
                    MEMBERSHIPPROMO.[AMOUNT],
                    MEMBERSHIPPROMO.[EXTENSIONVALUE],
                    MEMBERSHIPPROMO.[PROMOTIONTYPECODE],
                    MEMBERSHIPPROMO.[BASECURRENCYID]
                            from dbo.MEMBERSHIPPROMO
                            where
                                @INCLUDEINACTIVE = 1 or
                                ISACTIVE = 1
        end