Project

General

Profile

Download (347 Bytes)

update_data.txt

Luc Tran Van, 05/11/2023 02:47 PM

 
1 
UPDATE CM_REQUEST_TEMPLATE
2 
SET AUTH_STATUS = 'O'
3 
WHERE REQUEST_TEMPLATE_ID = 'CRTEM0000000168'
4 

    		
  

  

    
      5
    
    
      
declare @REPORT_NO NVARCHAR(50)=N'000132/2023TTR-0690604'


    		
  

  

    
      6
    
    
      
declare @REQUEST_TEMPLATE_ID NVARCHAR(20)=(SELECT REQUEST_TEMPLATE_ID FROM CM_REQUEST_TEMPLATE WHERE REPORT_NO=@REPORT_NO)


    		
  

  

    
      7
    
    
      
DELETE dbo.CM_TEMPLATE_NOTE WHERE REQ_ID = @REQUEST_TEMPLATE_ID