2.0 UPDATE TONG TIEN PUR 2021 457 - ANH CUONGVD.txt
| 1 |
DECLARE @DATE DATETIME, @REQ_ID VARCHAR(15) |
|---|---|
| 2 |
SET @DATE ='2021-04-16 12:00:00 AM' |
| 3 |
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000457') |
| 4 |
UPDATE TR_REQUEST_DOC_DT SET TOTAL_AMT =68134880 WHERE PRICE =85168.6 AND REQ_DOC_ID =@REQ_ID |
| 5 |
UPDATE TR_REQUEST_DOC SET TOTAL_AMT=714393280 WHERE REQ_ID =@REQ_ID |