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.

Did you try googlize that?

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

Thanks

There's some sites have desired data! but you've to pay! fits you?

Doesn't hurt to look at them, what are the sites and thanks!!!

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.