Home Forums SQL Server 7,2000 General Neighboring counties RE: Neighboring counties

  • August 3, 2006 at 1:28 pm

    #653195

    an interesting idea; i've got databases that have a lat/longitude for each county, so you could calculate where nearby counties are < 40 miles or something; but that's not what you were after, right?

    what happens if the county in question borders on another state? do you want all counties contiguous with that county, regardless of state, or just contiguous AND in that state?

    this would be a project i'd throw at an intern to gather the data; it's kind of neat, although i don't know how it would be of value yet.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!