Just wanted to pass along this article from SQLServerCentral on how you can use Google’s Geocode API within T-SQL. This is some very slick code. Geocode Addresses in T-SQL
—