spClone_ShoppingCartPart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SourceID	int	IN
@DestID	int	IN
Definition

Copy


            CREATE PROCEDURE [dbo].[spClone_ShoppingCartPart]
            (
                @PKID INT OUTPUT,
                @SourceID INT,
                @DestID INT
            ) as

                INSERT INTO [dbo].[ShoppingCartPart]
                (
                    SiteContentID,
                    AllowCreditCard,
                    AllowDirectDebit,
                    AllowPledge,
                    MerchantAccountID,
                    Active,
                    ExpirationDays,
                    ShowPaymentFormImmediately
                )
                select
                    @DestID,
                    AllowCreditCard,
                    AllowDirectDebit,
                    AllowPledge,
                    MerchantAccountID,
                    Active,
                    ExpirationDays,
                    ShowPaymentFormImmediately
                from [dbo].[ShoppingCartPart]
                where SiteContentiD = @SourceID;
                SELECT @PKID = @@Identity;