Returns the spatial union of all of the geometries in a group
SELECT ST_Geometry::ST_UnionAggr( Shape ) FROM SpatialShapes WHERE ShapeID IN ( 2, 6 )
SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension