with fix as (select guid, geometry::UnionAggregate(shape) as geom
from GeomCollection
group by guid)

UPDATE       CHM.OBJ_Geometry
SET                Geom = fix.geom from
CHM.OBJ_Geometry g inner join fix on g.guid = fix.guid