spGet_ShoppingCartMemberships

        CREATE procedure [dbo].[spGet_ShoppingCartMemberships](@ShoppingCartID integer) as
            select
                ID,
                ShoppingCartID,
                TransactionXml,
                AcknowledgementXml,
                Amount,
                CreateDate,
                UpdateDate,
                BenefitsHTML,
                AllowsMatchingGifts,
                CartSendMembershipAcknowledgementAlways
            from dbo.ShoppingCartMembership
            where ShoppingCartID = @ShoppingCartID
            order by CreateDate;