Aggregating Spatial Data

Spatial table data can be aggregate such as to get a high level map.  This code works for tables in SQL 2012.

SELECT    [Column Name]    ,geometry::UnionAggregate(geom.MakeValid()) AS goem
FROM             
GROUP BY [Column Name]