USP_DATALIST_MEMBERSHIPPROGRAM_PROMOTIONFORCLR

            create procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAM_PROMOTIONFORCLR
            (
                @MEMBERSHIPPROGRAMID uniqueidentifier = null
            )
            as
            begin

                select
                    MEMBERSHIPPROMO.ID,
                    MEMBERSHIPPROMO.NAME,
                    MEMBERSHIPPROMO.AMOUNT,
                    MEMBERSHIPPROMO.[PERCENT],
                    MEMBERSHIPPROMO.EXTENSIONVALUE,
                    MEMBERSHIPPROMO.ISACTIVE,
                    MEMBERSHIPPROMO.PROMOTIONTYPECODE,
                    MEMBERSHIPPROMO.DISCOUNTCALCULATIONTYPECODE,
                    MEMBERSHIPPROMO.EXTENSIONCALCULATIONTYPECODE,
                    MEMBERSHIPPROMO.BASECURRENCYID
                from
                    dbo.MEMBERSHIPPROMOAVAILABILITY
                    inner join dbo.MEMBERSHIPPROMO on MEMBERSHIPPROMOAVAILABILITY.MEMBERSHIPPROMOID = MEMBERSHIPPROMO.ID
                where
                    MEMBERSHIPPROMOAVAILABILITY.MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID

            end