spClone_ClientMemberships

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CloneSiteContentID	int	IN
@ClonedSiteContentID	int	IN
@CurrentUsersID	int	IN
Definition

Copy

            CREATE procedure [dbo].[spClone_ClientMemberships]
            (
                @PKID int output,
                @CloneSiteContentID int,
                @ClonedSiteContentID int,
                @CurrentUsersID int
            )
            as
                begin transaction;

                    declare @Guid uniqueidentifier;
                    set @Guid = newid();

                    insert into ClientMemberships (
                        SiteContentID,
                        OwnerID,
                        Guid,
                        MerchantAccount,
                        XMLData,
                        ShoppingCartPageID,
                        CartMessage,
                        CartSendMembershipAcknowledgementAlways,
                        AcknowledgementBlock,
                        RecurrenceOptionsTruePledge 
                    ) select 
                        @CloneSiteContentID,
                        OwnerID,
                        @Guid,
                        MerchantAccount,
                        XMLData,
                        ShoppingCartPageID,
                        CartMessage,
                        CartSendMembershipAcknowledgementAlways,
                        AcknowledgementBlock,
                        RecurrenceOptionsTruePledge 
                    from ClientMemberships
                    where SiteContentID = @ClonedSiteContentID;

                    select @PKID = @@identity;

                    exec spAuditThis @CurrentUsersID, 1, @Guid, 24;

                commit transaction;