Project

General

Profile

Download (380 Bytes)

New Text Document (2).txt

Luc Tran Van, 06/08/2025 04:24 PM

 
1 
UPDATE SHO_SERVICE SET SERVICE_ID = 'SS' + RIGHT('000000000000000000' + CONVERT(VARCHAR, (CONVERT(INT,RIGHT(SERVICE_ID, 2)) - 3)),13),
2 
SERVICE_CODE = 'DV/' + RIGHT('00000' + CONVERT(VARCHAR, (CONVERT(INT, RIGHT(SERVICE_CODE, 3)) - 3)), 3)
3 

    		
  

  

    
      4
    
    
      
UPDATE SHO_SERVICE_DT SET SERVICE_ID = 'SS' + RIGHT('000000000000000000' + CONVERT(VARCHAR, (CONVERT(INT,RIGHT(SERVICE_ID, 2)) - 3)),13)