Project

General

Profile

Download (417 Bytes)

UPDATE BACKDAY TT.txt

Truong Nguyen Vu, 10/02/2020 03:56 PM

 
1 
DECLARE @REQ_DT DATETIME,@REQ_ID VARCHAR(20)
2 
SET @REQ_DT = (SELECT REQ_DT FROM dbo.PL_REQUEST_DOC  WHERE REQ_CODE='0003/2020/TTr-0020005')
3 
SET @REQ_ID = (SELECT REQ_ID FROM dbo.PL_REQUEST_DOC  WHERE REQ_CODE='0003/2020/TTr-0020005')
4 

    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
UPDATE dbo.PL_REQUEST_DOC SET APPROVE_DT=@REQ_DT,EFFEC_DT=@REQ_DT WHERE REQ_ID=@REQ_ID


    		
  

  

    
      7
    
    
      
UPDATE dbo.PL_REQUEST_PROCESS SET APPROVE_DT= @REQ_DT WHERE REQ_ID=@REQ_ID AND STATUS='P'