Project

General

Profile

Download (829 Bytes)

06012021 FILE 4..0 CONFIG.txt

Luc Tran Van, 01/06/2021 04:43 PM

 
1 
UPDATE TL_USER SET RoleName ='PP' WHERE TLNANME ='hoangnt4'
2 
DECLARE @REQ_ID VARCHAR(15), @BRANCH_CREATE VARCHAR(15)
3 
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000891')
4 
UPDATE TR_REQUEST_DOC SET REQ_DT ='2020-11-16', APPROVE_DT ='2020-11-16' WHERE REQ_ID =@REQ_ID
5 
UPDATE PL_PROCESS SET APPROVE_DT ='2020-11-16' WHERE REQ_ID =@REQ_ID
6 
UPDATE TR_REQUEST_DOC_DT SET REQ_DT ='2020-11-17' WHERE REQ_DOC_ID =@REQ_ID
7 

    		
  

  

    
      8
    
    
      

    		
  

  

    
      9
    
    
      
SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000013')


    		
  

  

    
      10
    
    
      
SET @BRANCH_CREATE =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000013')


    		
  

  

    
      11
    
    
      
UPDATE TR_REQUEST_DOC SET DMMS_ID =(SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID =@BRANCH_CREATE), BRANCH_DVMS = @BRANCH_CREATE WHERE REQ_CODE ='PUR/2021/000013' AND REQ_ID =@REQ_ID