USP_DELETE_CMSTRANSACTIONSTATE

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



      CREATE procedure dbo.USP_DELETE_CMSTRANSACTIONSTATE
      (
          @ID uniqueidentifier
      )
      as
      begin

        insert into [dbo].[ARCHIVEDCMSTRANSACTIONS]  (TRANSACTIONID, ORDERID, DATA, STATUS, STATUSTEXT, TYPE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, RESULTCODE, FAILDATA)
        select                                        TRANSACTIONID, ORDERID, DATA, STATUS, STATUSTEXT, TYPE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, RESULTCODE, FAILDATA
        from [dbo].[CMSTRANSACTIONS]
        where ID=@ID;

        delete from [dbo].[CMSTRANSACTIONS] where ID = @ID;

        select @@ROWCOUNT;

      end