BEGIN TRAN

DECLARE @SID INT = 4049;
DECLARE @NewUpdated UNIQUEIDENTIFIER = NEWID();

SELECT * FROM SampleResults As SR Where SR.Results_Sample_ID_LNK = @SID

DELETE FROM SampleResults Where Results_Sample_ID_LNK = @SID

INSERT INTO SampleResults (
  Results_Value, 
  Results_Value2, 
  Results_Sample_ID_LNK,
  Results_Process_ID_LNK,
  Results_FirstReadUser_ID_LNK,
  Results_FirstReadDate,
  Results_FirstReadStatus,
  Results_FinalReadUser_ID_LNK,
  Results_FinalReadDate,
  Results_FinalReadStatus,
  Results_FinalResult,
  Results_UpdatedGuid,
  Results_Deleted)
VALUES
  (
    0,
    0,
    @SID,
    32,
    0,
    CURRENT_TIMESTAMP,
    0,
    0,
    CURRENT_TIMESTAMP,
    0,
    0,
    @NewUpdated,
    0
  )

  INSERT INTO SampleResults (
  Results_Value, 
  Results_Value2, 
  Results_Sample_ID_LNK,
  Results_Process_ID_LNK,
  Results_FirstReadUser_ID_LNK,
  Results_FirstReadDate,
  Results_FirstReadStatus,
  Results_FinalReadUser_ID_LNK,
  Results_FinalReadDate,
  Results_FinalReadStatus,
  Results_FinalResult,
  Results_UpdatedGuid,
  Results_Deleted)
VALUES
  (
    0,
    0,
    @SID,
    33,
    0,
    CURRENT_TIMESTAMP,
    0,
    0,
    CURRENT_TIMESTAMP,
    0,
    0,
    @NewUpdated,
    0
  )

SELECT * FROM SampleResults As SR Where SR.Results_Sample_ID_LNK = @SID

Rollback Tran