Project

General

Profile

Download (301 Bytes)

FILE 1 VAN HANH 0210.txt

An Nguyễn Văn, 10/02/2020 09:16 AM

 
1 
SELECT * FROM TR_REQ_PAY_SERVICE
2 
WHERE REQ_PAY_ID NOT IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_TYPE NOT IN ('I','D'))
3 

    		
  

  

    
      4
    
    
      
UPDATE TR_REQ_PAY_SERVICE SET REQ_PAY_ID= 'XX'+ RIGHT(REQ_PAY_ID,13)


    		
  

  

    
      5
    
    
      
WHERE REQ_PAY_ID NOT IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_TYPE NOT IN ('I','D'))