I don't know why he put a SELECT 0 in a CATCH block. FWIW, he also put a SELECT 1 at the bottom of the TRY block. Again, I'm thinking...

Thank you, Drew. To be honest with you I was afraid of modifying his code and potentially messing something up. Your example is an excellent one which "does no harm"...

Have a good time, Steve.

At home I use SQL Server 2016 Developer Edition, with the associated SSMS.

Tom Gillies (8/18/2016)

---

There's some nice examples there of how to do things better:

As for the, "I'd like to interface to your system" request, If I was charitable, I would like...

gvoshol 73146 (8/19/2016)

---

Have you considered what you will do with zip codes that cross county lines? Does your data source (when you decide on one) split the zip code...

I sympathize with David.Poole's predicament as well. I find interacting with government agencies to be a mixed bag. Some seem to do a good job of providing information and a...

This looks useful Ed, thank you.

TheSQLGuru (8/16/2016)

---

Rod at work (8/16/2016)

---

Thank you, Kevin. I agree that looks like it will work. The question I have is, where do I get the data in the first place?

(Internet...

Thank you, Kevin. I agree that looks like it will work. The question I have is, where do I get the data in the first place?

(Internet connectivity is much better...

I can't wait for space exploration to get beyond the confides of our planet! I hope that one day I'll be able to afford such travel.

And boy, do I remember...

WOW, I wish I had a professor like that when I went to college. Excellent object lesson.

Thanks for sharing, Ben.

Coincidentally in one of my emails today there was a newsletter from Toolbiox.com on a survey done across all sorts of career fields. 77% of all workers, regardless of their...

At my old job this was an issue I was concerned about. Since it was a very small IT shop and we (all 2 of us) had to wear multiple...

Ah, now I understand. Thanks, Gaz.