DECLARE @row INT, @jumlah INT, @TOTAL INT;
SET @row = 0;

SELECT * INTO #TEMP_A FROM
(
	SELECT ROW_NUMBER() OVER(ORDER BY id_obat ASC) AS ROW, * FROM stok
)A  ORDER BY ED ASC



WHILE @row < 3
BEGIN
	SET @row = @row + 1;

	SET @jumlah = (SELECT jumlah FROM #TEMP_A WHERE ROW = @row)

--	SET @TOTAL = (SELECT SUM(@jumlah))
	IF @jumlah < 30
	BEGIN
		UPDATE #TEMP_A SET jumlah = jumlah - 30 WHERE ROW = @row
	END

END;

	SELECT * FROM #TEMP_A

DROP TABLE #TEMP_A

GO