Project

General

Profile

Download (382 Bytes)

FILE 8.txt

Truong Nguyen Vu, 09/21/2020 03:10 PM

 
1 
SELECT * FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE PROCESS_ID='APPROVE') AND PROCESS_ID ='APPROVE' AND STATUS='U'
2 

    		
  

  

    
      3
    
    
      

    		
  

  

    
      4
    
    
      
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE ID IN (SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE PROCESS_ID='APPROVE') AND PROCESS_ID ='APPROVE' AND STATUS='U'


    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
)