Corey,

Very interesting article.  Do you know if Yahoo places restrictions on the number of records passed to their system for Geocoding before they would require a license?

I make extensive use of geocoding already using licensed software.  It would be very nice to append lat/long on the database to speed things up.  The cost of passing over 10 million customer records through this type of tool may make it impractical for myself to use.

Any thoughts?

This is really neat.

What is the easiest way to process the XML if you just write a script to capture the URL's to a file?

Corey,

This is a very interesting article, but how do you create the DLL with Visual Studio 2005 Standard Edition?  I do not have the option of making a "SQL Server Project".

Thanks,

Allan

The "Class Library" method worked.  Since I don't have clean addresses to start with, I changed the code to take advantage of the "Location" feature in Yahoo (http://developer.yahoo.com/maps/rest/V1/geocode.html):

I also modified the Stored Procedure to get rid of the extra parameters.  Some warning messages are pretty long, so you might consider setting the length of the "warning" column to at least 250.

This is a very handy program.  Thanks for posting it, Corey!

Allan