USP_CLONESITE_ADVANCEDDONATIONFORM

create procedure [dbo].[USP_CLONESITE_ADVANCEDDONATIONFORM]
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
) 
as
begin
    --Get email template ids

    declare @PartEmailTemplate table([SiteContentID] int, [EmailTemplateId] int)
    insert into @PartEmailTemplate select SiteContentID, CAST(value as int) from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid, 9111, 'EmailTemplateId')

    --Insert new email acknowledgement templates

    declare @IDs xml
    set @IDs = 
    (
        select EmailTemplateId as ID
        from @PartEmailTemplate
        FOR XML RAW, ELEMENTS
    )        
    exec spCloneSite_EmailTemplate @TargetClientSitesID, @CurrentUserID, @CopyBatchGUID, @IDs

    --Update properties

    declare @data xml
    set @data =
    (
        select PET.SiteContentID, ET.ID as Value
        from @PartEmailTemplate PET
        inner join dbo.emailtemplate ET on ET.CopySourceID = PET.EmailTemplateId
        where ET.CopyBatchGUID = @CopyBatchGuid    
        FOR XML RAW, ELEMENTS
    )
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'EmailTemplateId', @data
end