Project

General

Profile

Download (332 Bytes)

lay_data.txt

Luc Tran Van, 05/11/2023 04:10 PM

 
1 
DECLARE @REQ_ID VARCHAR(15)
2 
SELECT @REQ_ID = REQUEST_TEMPLATE_ID FROM dbo.CM_REQUEST_TEMPLATE WHERE REPORT_NO = '002163/2023/TTr-0690604'
3 

    		
  

  

    
      4
    
    
      
SELECT * FROM dbo.CM_REQUEST_TEMPLATE WHERE REQUEST_TEMPLATE_ID = @REQ_ID


    		
  

  

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


    		
  

  

    
      6
    
    
      
SELECT * FROM dbo.CM_TEMPLATE_LOG WHERE REQ_ID = @REQ_ID