DELETE FROM T24R001.DBO.TDS_TYPE_MASTER INSERT INTO T24R001.DBO.TDS_TYPE_MASTER SELECT * FROM COMMON.DBO.TDS_TYPE_MASTER UPDATE T24R001.DBO.ACCOUNT_MASTER SET TDSAccount = T1.F2 FROM (SELECT AccCode AS F1, TDSAccount AS F2 FROM T23R001.DBO.ACCOUNT_MASTER) AS T1 WHERE AccCode = T1.F1