Yahoo! PlaceFinder is a geocoding Web service that helps developers make their applications location-aware by converting street addresses or place names into geographic coordinates. This solution (created with Visual Studio 2010) integrates Yahoo! Placefinder directly into SQL Server to return geographic data in a tabular format.
Visit http://developer.yahoo.com/geo/placefinder/ to find out more about the Yahoo! PlaceFinder API.
Visit http://www.msdn.com to download a 90-day trial version of Visual Studio 2010.
You should be able to unzip the file, then open it in Visual Studio. From there, connect it to your database, build, deploy, and enjoy.
My coding skills are still pretty weak. I won't be able to offer any help with deploying the solution. Please add comments for design improvements or deployment tips.