Project

General

Profile

Download (422 Bytes)

script_lui_ngay.txt

Luc Tran Van, 04/19/2023 01:39 PM

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

    		
  

  

    
      4
    
    
      

    		
  

  

    
      5
    
    
      
EXEC dbo.CM_REQUEST_TEMPLATE_Back_date @p_REQUEST_TEMPLATE_ID = @REQ_ID, -- nvarchar(200)


    		
  

  

    
      6
    
    
      
                                       @p_REPORT_DT = '06/03/2023',            -- varchar(20)


    		
  

  

    
      7
    
    
      
                                       @p_MAKER_ID = 'quanvta'              -- varchar(25)