USP_CLONESITE_WEBLOG

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


    insert into dbo.NewsChannels(SiteContentID, PublicationDate, SiteImageID, Guid, AllowMembers, PersonalPageDataID, Title, LinkURL, Description, Copyright, EditorEMail, ImageTitle, ImageLink, Moderated)
    select
    SC.ID,
    NC.PublicationDate,
    ISNULL(SI.ID,NC.SiteImageID),
    NEWID(),
    NC.AllowMembers,
    NC.PersonalPageDataID,
    NC.Title,
    NC.LinkURL,
    NC.Description,
    NC.Copyright,
    NC.EditorEMail,
    NC.ImageTitle,
    NC.ImageLink,
    NC.Moderated
    from dbo.NewsChannels NC
    inner join dbo.SiteContent SC on SC.CopySourceID = NC.SiteContentID
    left outer join dbo.SiteImages SI on SI.CopySourceID = NC.SiteImageID and SI.CopyBatchGUID = @CopyBatchGuid
    where SC.CopyBatchGUID = @CopyBatchGuid

    --Update XML Data

    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, NC.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,65, 'ClientNewsChannelID') P
        inner join dbo.NewsChannels NC on NC.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'ClientNewsChannelID', @Data