productNr
curQuantity<br />
Select-query to get curQuantity. newQuantity = curQantity + (added or subtractet) update-query to set newQantity.
DECLARE @OrigQuantity INT SELECT TOP 1 @OrigQuantity = curQuantity FROM Products WHERE Id=3 UPDATE Products SET curQuantity = @OrigQuantity - 2 WHERE Id=3 SELECT @OrigQuantity
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)