Project

General

Profile

Download (398 Bytes)

lấy data PUR_2023_000572.txt

Luc Tran Van, 03/29/2023 01:41 PM

 
1 
DECLARE @req_id varchar(20)
2 
SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000572'
3 
SELECT * FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000572'
4 

    		
  

  

    
      5
    
    
      
SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @req_id


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
SELECT * FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN (SELECT ID FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @req_id)