Calculate sum of amount in SQL

Hi moayyad,

The query should be like below.

SQL

DECLARE @SumAmount AS TABLE(Code INT,SumAmount INT)
INSERT INTO @SumAmount VALUES(1,NULL)
INSERT INTO @SumAmount VALUES(2,NULL)
INSERT INTO @SumAmount VALUES(3,NULL)
SELECT * FROM @SumAmount

DECLARE @Amount AS TABLE(Code INT,Amount INT)
INSERT INTO @Amount VALUES(1,100)
INSERT INTO @Amount VALUES(1,50)
INSERT INTO @Amount VALUES(2,10)
INSERT INTO @Amount VALUES(2,20)
SELECT * FROM @Amount

UPDATE sa
SET SumAmount = (SELECT SUM(Amount) FROM @Amount WHERE Code = sa.Code)
FROM @SumAmount sa

SELECT * FROM @SumAmount

Screenshot