USP_RECORDOPERATION_ARCHIVEDEADBBSPTRANSACTION

create procedure dbo.USP_RECORDOPERATION_ARCHIVEDEADBBSPTRANSACTION
(
  @ID uniqueidentifier,
    @KEYGUID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    set nocount on;
  --check deletion rules, if any


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

  declare @ROWEXISTS bit = 0;
  select @ROWEXISTS = 1 from dbo.CMS_UNPROCESSEDBBSPTRANSACTION where BBSPTOKEN = @KEYGUID;

  if @ROWEXISTS = 0
  begin
    declare @DATA xml = null;
    select @DATA = DATA from dbo.CMS_SESSIONVARIABLEBACKUP where KEYGUID = @KEYGUID;

    insert into dbo.CMS_UNPROCESSEDBBSPTRANSACTION(BBSPTOKEN, DATA, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values(@KEYGUID, @DATA, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
  end

  select @ID = ID from dbo.CMS_SESSIONVARIABLEBACKUP where KEYGUID = @KEYGUID;

    -- use the system generated delete routine to allow proper recording of the deleting agent

    exec USP_CMS_SESSIONVARIABLEBACKUP_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
    return 0;

end