Project

General

Profile

UPDATE TRADE_HIST.txt

Truong Nguyen Vu, 11/17/2020 03:41 PM

 
1
	  UPDATE dbo.PL_TRADEDETAIL_HIST SET AMT_ETM=AMT_APP,M10=AMT_ETM,M1=1 WHERE EXISTS (SELECT PT.TRADE_ID FROM dbo.PL_TRADEDETAIL PT WHERE PT.TRADE_ID=PL_TRADEDETAIL_HIST.TRADE_ID AND PL_TRADEDETAIL_HIST.AMT_ETM=PT.AMT_APP)
2
					  UPDATE dbo.PL_TRADEDETAIL_HIST SET AMT_APP= M10 WHERE M1=1