0

I wanted to ask this before I tried to build these two large tables myself. Does anyone know where or if I can find an MS Sql table of the United States, Cites and States. Possibly with the relationship between state and cites already built, or even an Sql procedure that I can run.

Any help will be appreciated,
Thanks.

2
Contributors
6
Replies
7
Views
8 Years
Discussion Span
Last Post by WhYuLoOkIn
0

Yea I looked on google, I really don't want to do this by hand any help would be appreciated.

Thanks

0

Hey thanks for trying to help me but I decided to write a script in java to read in the city names of each state from a text file then put them in the correct sql procedure format and writes them to a text file. It takes time but not as much time if I where to insert each city separately.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.