USP_CLONESITE_ANONNEWSLETTERSUBSCRIPTION
Handles the Anonymous Newsletter Subscription-specific steps for cloning a CMS site.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SourceClientSitesID | int | IN | |
| @TargetClientSitesID | int | IN | |
| @CurrentUserID | int | IN | |
| @CopyBatchGuid | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_CLONESITE_ANONNEWSLETTERSUBSCRIPTION
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as
insert into dbo.AnonymousNewsletterPart (ContentID,Title,AfterUpdatePageID,NewsletterID)
select
SC.ID,
ANP.Title,
ISNULL(SP.ID,ANP.AfterUpdatePageID),
ANP.NewsletterID
from dbo.AnonymousNewsletterPart ANP
inner join dbo.SiteContent SC on SC.CopySourceID = ANP.ContentID
left outer join dbo.SitePages SP on SP.CopySourceID = ANP.AfterUpdatePageID and SP.CopyBatchGUID = @CopyBatchGuid
where SC.CopyBatchGUID = @CopyBatchGuid