Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 Script to populate US Cities and States???

Author  Topic 

wgpubs
Yak Posting Veteran

67 Posts

Posted - 2009-06-17 : 19:00:56
I have a table of Cities and a table of States ... I'm sure something like this is out there ... but I'm looking for a simple script to populate both. Again, this is only for US city/states.

Thanks - wg

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-17 : 19:21:34
See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=127569



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

wgpubs
Yak Posting Veteran

67 Posts

Posted - 2009-06-17 : 20:20:09
That is helpful for the STATE part ... but what about CITIES?

tahnks again!

quote:
Originally posted by Peso

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=127569



E 12°55'05.63"
N 56°04'39.26"


Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-17 : 20:30:20
I think Wikipedia and Google is mentioned in that topic above with link.
Why don't you try those?


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-17 : 20:39:25
First link I got from Google is this
http://www.city-data.com/




E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

wgpubs
Yak Posting Veteran

67 Posts

Posted - 2009-06-26 : 19:43:23
I'm really looking for a script again that I could just run that would populate US cities/states. There has got to be something out there.

I looked at your resources and while its comprehensive ... looks like a pain to assimilate into a script when someone has probably done so already.

thanks

quote:
Originally posted by Peso

First link I got from Google is this
http://www.city-data.com/




E 12°55'05.63"
N 56°04'39.26"


Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-27 : 02:50:11
I have an idea?
What if this haven't been done before? Now YOU have the chance to contribute to the SQLTeam society...



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -