--Copy data from column to column
UPDATE [dbo].[CZHJOriginalData]
set [OEMIdentified] = ##table1.[VehiclePartOemID]from [CZHJOriginalData] COD
join ##table1 on ##table1.ID = COD.ID
where ##table1.OEM2 is not null
--Copy data from column to column
UPDATE [dbo].[CZHJOriginalData]
set [OEMIdentified] = ##table1.[VehiclePartOemID]