Project

General

Profile

Download (321 Bytes)

FILE 2- GETDATA.txt

Truong Nguyen Vu, 10/19/2020 01:28 PM

 
1 

    		
  

  

    
      2
    
    
      
DECLARE @REQ_ID VARCHAR(20)


    		
  

  

    
      3
    
    
      
SELECT * FROM dbo.PL_REQUEST_DOC A WHERE REQ_CODE='0014/2020/TTr-0690907'


    		
  

  

    
      4
    
    
      
SET @REQ_ID = (SELECT A.REQ_ID FROM dbo.PL_REQUEST_DOC A WHERE REQ_CODE='0014/2020/TTr-0690907')


    		
  

  

    
      5
    
    
      
SELECT * FROM dbo.PL_REQUEST_DOC_DT WHERE REQ_ID=@REQ_ID


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
SELECT * FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID=@REQ_ID