Project

General

Profile

UPDATE PYC.txt

Truong Nguyen Vu, 10/07/2020 01:25 PM

 
1
UPDATE dbo.TR_REQUEST_DOC SET TOTAL_AMT=(SELECT SUM(TOTAL_AMT) FROM dbo.TR_REQUEST_DOC_DT WHERE REQ_DOC_ID='TRRDI001055584') WHERE REQ_ID='TRRDI001055584'
2
UPDATE dbo.TR_REQUEST_DOC_DT SET PRICE_ETM='56500',TOTAL_AMT_ETM='864450000',PRICE='56500',TOTAL_AMT='864450000' WHERE REQDT_ID='TRRDDI01055867'