wbrianwhite (7/21/2010)

---

Since you were using lat/long datatypes - did you look into the geometry data type?

http://msdn.microsoft.com/en-us/library/bb964711.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlspatial/thread/c557032a-038e-480c-84e8-7f0ad72e1af7

I've read about it a little, but haven't used it yet. Seems to be the way to go if you're going CLR.