Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

1: Where's the code gone? 2: Dumb question 3: Earlier Versions of SQL Server and VS Expand / Collapse
Author
Message
Posted Tuesday, November 13, 2007 12:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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

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!

Post #421357
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse