Hi everyone,
I'm taking a crack at setting up some Geo Areas, and I was wondering if anyone has done this for their venues and would be willing to share a sample of their code from their updated stored procedures? Maybe it's just 'Friday Brain', but I'm having a bit of bother trying to convert from US to UK poscode formats. I'd be happy to share my final output with you!
Cheers,Kathleen
We don't do anything fancy with US postcodes, we just categorize them all as Foreign. Our Geo-Areas are as follows:id description ----------- ------------------------------ 1 Inner London2 Neighbours3 Outer London4 South East5 Other UK addresses0 Bad Address UK6 Foreign If you want the code for this let me know and I can send it on; however I doesn't sound as if it is as detailed as you would like.
Caryl
Hi,
I was looking at using the scripts at the following SQL Central page to do this in the future, though haven't got round to it yet. Hopefully the link is helpful to you though.
http://www.sqlservercentral.com/articles/geocode/70061/