USP_CLONESITE_PAYMENT2

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

    declare @IDs xml
    set @IDs = 
    (
        select SCS.EMAILTEMPLATEID as ID
        from dbo.SHOPPINGCARTSETTINGS SCS
        inner join dbo.SiteContent OLDSC on OLDSC.Guid = SCS.ID
        inner join dbo.SiteContent SC on SC.CopySourceID = OLDSC.ID
        where SC.CopyBatchGUID = @CopyBatchGuid
        FOR XML RAW, ELEMENTS
    )        
    exec spCloneSite_EmailTemplate @TargetClientSitesID,@CurrentUserID,@CopyBatchGUID,@IDs

    declare @CHANGEAGENTID uniqueidentifier
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output                
    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()


    insert into dbo.SHOPPINGCARTSETTINGS (ID, MERCHANTACCOUNTID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, EMAILTEMPLATEID, ALLOWPLEDGE, ALLOWDIRECTDEBIT, CONFIRMATIONBLOCK, DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES, ALLOWCREDITCARD, REQUIREFIRSTNAME, REQUIRETITLE, REQUIREPHONE, ALLOWINLINEREGISTRATION, BBPAYTEMPLATEID)
    select
    SC.GUID,
    SCS.MERCHANTACCOUNTID,
    @CHANGEAGENTID,
    @CHANGEAGENTID, 
    @CURRENTDATE, 
    @CURRENTDATE, 
    ET.ID, 
    SCS.ALLOWPLEDGE, 
    SCS.ALLOWDIRECTDEBIT,     
    dbo.UFN_UPDATECOPYCONTENTHTML (SCS.CONFIRMATIONBLOCK, @CopyBatchGuid),
    SCS.DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES,
    SCS.ALLOWCREDITCARD,
    SCS.REQUIREFIRSTNAME,
    SCS.REQUIRETITLE,
    SCS.REQUIREPHONE,
    SCS.ALLOWINLINEREGISTRATION,
    SCS.BBPAYTEMPLATEID
    from dbo.SHOPPINGCARTSETTINGS SCS
    inner join dbo.EmailTemplate ET on ET.CopySourceID = SCS.EMAILTEMPLATEID and ET.CopyBatchGUID = @CopyBatchGuid
    inner join dbo.SiteContent OLDSC on OLDSC.Guid = SCS.ID
    inner join dbo.SiteContent SC on SC.CopySourceID = OLDSC.ID and SC.CopyBatchGUID = @CopyBatchGuid