UPDATE PYC.txt
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' |