This question Whats the easiest way to get sql 08 spatial data onto a map? (and many other articles) recommends Craig Dunn's Geoquery, but all the download links appear to be kaput.
SQL Server Managament Studio's spatial results tab will show a single dataset, and this MSDN article, Spatial Data Support In SQL Server 2008 mentions a workaround using
UNION ALL to display point data overlayed on a map:
SELECT geog, name FROM Mondial.dbo.city WHERE geog IS NOT NULL UNION ALL SELECT geog, cntry_name FROM SpatialSamples.dbo.cntry00
Whenever I try something similar, I only ever get a single resultset displayed.
Is there something built into either SQL Server 2008 or 2012 to do this?