dwain.c (12/12/2012)
mickyT (12/12/2012)
Pretty cool Micky!
Do you need to run anything special on SQL 2008 to support the internal functions you're calling?
Happy that someone actually read the article.
2008 comes with the geography and geometry as standard. Management Studio will also give you a reasonably simply map view of the data if you include a geography/geometry column. Just click on the spatial tab in the results pane.
The trick is making sure that you pick the right SRID for the data. I used 4326 (WGS84). This is the same coordinate system used by GPS units.