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

UPDATE CUSTOMER_MASTER SET CustName = T1. F2, CustGrpCode = T1. F3, CustAdd1 = T1. F4, CustAdd2 = T1. F5, CustAdd3 = T1. F6, CustCityName = T1. F7, CustCityPin = T1. F8, CustPhone = T1. F9, CustMobile = T1. F10, CustFax = T1. F11, CustEmail = T1. F12 
FROM (SELECT CustCode AS F1, CustName AS F2, CustGrpCode AS F3, CustAdd1 AS F4, CustAdd2 AS F5, CustAdd3 AS F6, CustCityName AS F7, CustCityPin AS F8, CustPhone AS F9, CustMobile AS F10, CustFax AS F11, CustEmail AS F12 FROM T202122.dbo.CUSTOMER_MASTER) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT = CustCode