Project

General

Profile

Download (1.05 KB)

UPDATE DATA NS.txt

Truong Nguyen Vu, 10/07/2020 11:09 AM

 
1 

    		
  

  

    
      2
    
    
      
--ROLBACK NS


    		
  

  

    
      3
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM-1540712800 WHERE TRADE_ID='PLT000000071219'


    		
  

  

    
      4
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM-782100000,AMT_RECEIVE_TF=AMT_RECEIVE_TF-382100000 WHERE TRADE_ID='PLT000000071359'


    		
  

  

    
      5
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM-230325000 WHERE TRADE_ID='PLT000001071868'


    		
  

  

    
      6
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM-157000000 WHERE TRADE_ID='PLT000001071909'


    		
  

  

    
      7
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM-85000000 WHERE TRADE_ID='PLT000001071885'


    		
  

  

    
      8
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_TF=AMT_TF-382100000 WHERE TRADE_ID='PLT000000071219'


    		
  

  

    
      9
    
    
      

    		
  

  

    
      10
    
    
      
-- UPDATE NS


    		
  

  

    
      11
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM+ 1769316453 WHERE TRADE_ID='PLT000000071210'


    		
  

  

    
      12
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM+ 596987006 WHERE TRADE_ID='PLT000000071348'


    		
  

  

    
      13
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM+ 153000000 WHERE TRADE_ID='PLT000001071884'


    		
  

  

    
      14
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM+ 2811900000 WHERE TRADE_ID='PLT000001071908'


    		
  

  

    
      15
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM =AMT_ETM+ 544350000 WHERE TRADE_ID='PLT000001071867'