I worked for one of the software vendors for healthcare products. They're out of business now. We actually had very good developers, but a CEO that thought that IT knowledge...

It comes down to the classic DBA answer, it depends. I've primarily done work for internal applications, code that runs in-house for a company doing X. Platforms I've done that...

I've seen similar behavior. I never saw that in 2000.

I have to agree. In a real interview situation this code would scare me off.

Great response. First, I was joking about actually using this as an interview question. However, the excercise is interesting because it does force you to apply logic and a bit...

I have to say I was really surprised at how much response this little article generated. I dashed it off after we had our fun with it. I didn't think...

Ladies... The signal to noise ratio is starting to drop a bit. This was supposed to be a bit of candy for some intellectual stimulation a little bit different than...

Looks cool. I'm going to pass it out to the team & see what they think.

All true. Honestly we only allowed it to pass because all the answers we were getting were so damned pathetic. We also allowed people count dropping and recreating the proc...

I just wish it was only people interviewing for their first jobs. We're getting people with 5-8 years of "experience" that don't know the answer. I'd attribute it to nervousness,...

I'm sorry, I've only got 2005 installed on my systems these days. I can't readily test this.

True.

Hey, thanks for the reply to the article. Yes, I'd like to see a mechanism for unit testing SSIS as well. I think it'd probably be more useful than testing...

Forgive us our typos. Absolutely. The most you'd get gigged for only going to 99 is some good natured ribbing about being premature or something.

It's amazing how much discussion what...

Yikes.

I haven't seen that many GOTO's in quite a while. Nice job.