Querying distances using Spatial data types in SQL 2008http://msmvps.com/blogs/robfarley/archive/2008/01/08/querying-distances-using-spatial-data-types-in-sql-2008.aspxSQL Server 2008 has spatial types which are very useful for all kinds of applications. I thought it would be nice to produce one of those charts like you get in maps, telling you the distance between cities. So I start by populating the data. This usesenCommunityServer 2008.5 SP2 (Build: 40407.4157)Microsoft Tech@Night SQL Server 2008 Wrap-Up St. Gallen 24. Januar 2008http://msmvps.com/blogs/robfarley/archive/2008/01/08/querying-distances-using-spatial-data-types-in-sql-2008.aspx#1488857Thu, 31 Jan 2008 20:31:07 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1488857Trivadis IMS Microsoft Team Blog<p>Auch in St. Gallen sind am letzten Tech@Nigth Anlass zum Themas SQL Server 2008 noch Fragen aufgetaucht</p> <img src="http://msmvps.com/aggbug.aspx?PostID=1488857" width="1" height="1">Microsoft Tech@Night SQL Server 2008 Wrap-Up St. Gallen 24. Januar 2008http://msmvps.com/blogs/robfarley/archive/2008/01/08/querying-distances-using-spatial-data-types-in-sql-2008.aspx#1488798Thu, 31 Jan 2008 19:46:51 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1488798Trivadis IMS Microsoft Team Blog<p>Auch in St. Gallen sind am letzten Tech@Nigth Anlass zum Themas SQL Server 2008 noch Fragen aufgetaucht</p> <img src="http://msmvps.com/aggbug.aspx?PostID=1488798" width="1" height="1">