1: Where's the code gone? 2: Dumb question 3: Earlier Versions of SQL Server and VS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Corey Bunch » 1: Where's the code gone? 2: Dumb question 3:...

1: Where's the code gone? 2: Dumb question 3: Earlier Versions of SQL Server and VS

Rate Topic

Display Mode

Topic Options

Author

Message

Jonathan Armstrong

Posted Tuesday, November 13, 2007 12:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 29, 2012 5:21 PM
Points: 7, Visits: 55

Hi, what a fantastic article! There are just three small problems;

1. I just clicked the link that says "The source for the C# assembly can be downloaded here." , which points to http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/geocodingwithsqlserver2005/2373/YahooGCSQL.txt

However, I got an error that says the page could not be found Crying

2. I have a dumb question: I just read Zootie's post, which appears to provide an alternative C# code assembly under "Function Assembly Code", and code to create the necessary functions under "SQL Installation". But I can't figure out what is the following code for:

insert tmpAddressGeocode
(
[AddressGuid]
,[Latitude]
,[Longitude]
,[Address]
,[City]
,[State]
,[Zip]
,[Country]
,[Precision]
,[Warning]
)
select top 100
addr.AddressGuid,
gc.*
from
dbo.AddressTbl addr with (NoLock)
left join tmpAddressGeocode alldone with (NoLock)
on alldone.AddressGuid = addr.AddressGuid
cross apply dbo.fncGeocodeByAddress (
addr.StreetAddress1 + coalesce (' ' + StreetAddress2,''),
addr.CityName,
addr.State,
addr.Zip,
'YahooDemo' ) gc
where
alldone.AddressGuid is Null

Can anyone tell me?

3: Is it possible to use Corey Bunch's ORIGINAL code with earlier versions of SQL Server and Visual Studio?

Sorry for the dumb questions folks!

Blink

Post #421357

« Prev Topic | Next Topic »

Permissions