SQL Server combine Update and Delete
You can't combine them in one statement but you can wrap them into one transaction.

BEGIN TRANSACTION
  update a
  set a.value = a.value + b.value
  from Table1 a
  join Table2 b on a.ID = b.ID;

  DELETE FROM Table1 WHERE Table1.Value &gt; @Constant;
COMMIT TRANSACTION ;