ROUND NSCP.txt
| 1 |
UPDATE dbo.PL_TRADEDETAIL SET AMT_APP=ROUND(AMT_APP,0) |
|---|---|
| 2 |
UPDATE dbo.PL_TRADEDETAIL SET PRICE=ROUND(PRICE,0) |
| 3 |
UPDATE dbo.PL_IMPORT_DT SET TOTAL_AMT=ROUND(TOTAL_AMT,0) |
| 4 |
UPDATE dbo.PL_TRADEDETAIL_HIST SET AMT_APP=ROUND(AMT_APP,0) |
| 5 |
UPDATE dbo.PL_MASTER SET TOTAL_AMT=(SELECT SUM(AMT_APP) FROM dbo.PL_TRADEDETAIL WHERE PL_TRADEDETAIL.PLAN_ID=PL_MASTER.PLAN_ID) |