-------------RUN IN ALL YEAR
INSERT INTO SUPPLIER_GROUP_MASTER SELECT * FROM T202122.DBO.SUPPLIER_GROUP_MASTER WHERE SuppGrpCode COLLATE DATABASE_DEFAULT NOT IN (SELECT SuppGrpCode FROM SUPPLIER_GROUP_MASTER)

UPDATE SUPPLIER_MASTER SET SuppName = T1. F2, SuppGrpCode = T1. F3, SuppAdd1 = T1. F4, SuppAdd2 = T1. F5, SuppAdd3 = T1. F6, SuppCityName = T1. F7, SuppCityPin = T1. F8, SuppPhone = T1. F9, SuppMobile = T1. F10, SuppFax = T1. F11, SuppEmail = T1. F12 
FROM (SELECT SuppCode AS F1, SuppName AS F2, SuppGrpCode AS F3, SuppAdd1 AS F4, SuppAdd2 AS F5, SuppAdd3 AS F6, SuppCityName AS F7, SuppCityPin AS F8, SuppPhone AS F9, SuppMobile AS F10, SuppFax AS F11, SuppEmail AS F12 FROM T202122.DBO.SUPPLIER_MASTER) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT = SuppCode