USP_CLONESITE_CONTENTCOMPARISON

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


INSERT INTO ContentComparisonPart
        (
              SiteContentId,
              TargetPID, 
              StartedDate,
              EndedDate,
              Threshold
        )
    SELECT SC.ID,
           SP.ID,
           null,
           null,
           CCP.Threshold
    from ContentComparisonPart CCP
    inner join SiteContent SC on SC.CopySourceID = CCP.SiteContentID and SC.CopyBatchGUID = @CopyBatchGUID
    inner join SitePages SP on SP.CopySourceID = CCP.TargetPID and SP.CopyBatchGUID = @CopyBatchGUID

INSERT INTO ContentComparisons
        (
            CCPID,
            CID,
            Selected,
            NumDisplays,
            Conversions
        )
    SELECT CCP2.ID,
           ISNULL(SC2.ID,CC.CID),
           0,
           0,
           0
    from ContentComparisons CC
    inner join ContentComparisonPart CCP on CC.CCPID = CCP.ID
    inner join SiteContent SC1 on SC1.CopySourceID = CCP.SiteContentID and SC1.CopyBatchGUID = @CopyBatchGUID
    inner join ContentComparisonPart CCP2 on CCP2.SiteContentID = SC1.ID
    left join SiteContent SC2 on SC2.CopySourceID = CC.CID and SC2.CopyBatchGUID = @CopyBatchGUID