USP_CLONESITE_SITEPAGE_BBPAYTEMPLATEVERSION

create procedure dbo.USP_CLONESITE_SITEPAGE_BBPAYTEMPLATEVERSION
(
  @CopyBatchGUID uniqueidentifier
)
as
begin
      declare @CHANGEAGENTID uniqueidentifier;
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    insert into dbo.CMSSitePageBBPayTemplateVersion(SitePageId, BBPayTemplateVersion, EnvironmentId, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    -- Grab the template settings from dbo.CMSSitePageBBPayTemplateVersion that match the page id of the original pages

    -- Those original page ID from the CopyBatchGuid matching their new pages

    -- The original page ID = CopySourceId

    select PAGE.ID, BBPAY.BBPayTemplateVersion, BBPAY.ENVIRONMENTID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
    from dbo.CMSSitePageBBPayTemplateVersion BBPAY
    inner join dbo.SitePages PAGE on BBPAY.SitePageId = PAGE.CopySourceId and PAGE.CopyBatchGuid = @CopyBatchGUID;
end