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

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