USP_CLONESITE_POLL

Handles the Poll-specific steps for cloning a CMS site.

Parameters

Parameter	Parameter Type	Mode
@SourceClientSitesID	int	IN
@TargetClientSitesID	int	IN
@CurrentUserID	int	IN
@CopyBatchGuid	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_CLONESITE_POLL
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as


    insert into dbo.SitePolls(ID,ClientSitesID,LinkText,Question,RandomizeAnswers,AttributeTypesID,LastActivityDate,Closed)
    select
    SC.ID,
    SC.ClientSitesID,
    SP.LinkText,
    SP.Question,
    SP.RandomizeAnswers,
    SP.AttributeTypesID,
    SP.LastActivityDate,
    0
    from dbo.SitePolls SP
    inner join dbo.SiteContent SC on SC.CopySourceID = SP.ID
    where SC.CopyBatchGUID = @CopyBatchGuid

    insert into dbo.SitePollAnswers(SeqNbr,SitePollsID,Answer)
    select
    SPA.SeqNbr,
    SC.ID,
    SPA.Answer
    from dbo.SitePollAnswers SPA
    inner join dbo.SiteContent SC on SC.CopySourceID = SPA.SitePollsID
    where SC.CopyBatchGUID = @CopyBatchGuid