Project

General

Profile

Download (433 Bytes)

CAP NHAT NHA CUNG CAP.txt

Luc Tran Van, 07/28/2020 06:34 PM

 
1 
UPDATE  CM_SUPPLIER   SET  ACC_NAME_OUT = ACC_NAME, ACC_NUM_OUT= ACC_NUM, BANK_NAME_OUT= BANK_NAME, ACC_NAME='', ACC_NUM='', BANK_NAME ='' WHERE ACC_NAME NOT LIKE N'%Bản Việt%' or ACC_NAME NOT LIKE N'%BVB%'
2 

    		
  

  

    
      3
    
    
      
UPDATE CM_SUPPLIER SET ACC_NUM ='00'+ACC_NUM WHERE LEN(ACC_NUM)=11 AND ACC_NUM IS NOT NULL AND ACC_NUM <>''


    		
  

  

    
      4
    
    
      

    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
UPDATE CM_SUPPLIER SET ACC_NUM ='0'+ACC_NUM WHERE LEN(ACC_NUM)=12 AND ACC_NUM IS NOT NULL AND ACC_NUM <>''