Project

General

Profile

Download (481 Bytes)

07012021 FILE 2.0 UPDATE DATA.txt

Luc Tran Van, 01/07/2021 01:32 PM

 
1 
EXEC TL_SYSROLE_LIMIT_Auto '', 'ADV_PAY'
2 

    		
  

  

    
      3
    
    
      
DECLARE @REQ_ID VARCHAR(15), @BRANCH_CREATE VARCHAR(15)


    		
  

  

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


    		
  

  

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


    		
  

  

    
      6
    
    
      
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/000027' AND REQ_ID =@REQ_ID