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.

WOO HOO!

A CLR solution. Thanks Adam.

Absolutely more appropriate languages than SQL. I'm not serious about putting this on an interview. This was just some geek fun that we had one morning at work. Actually we...

Oh boo. That's so procedural. Not set based at all.

What? Are you some kind of developer or something?

Nice job though.

I had this query from Itzik too. I didn't want to use it in relation to the article. It works really well for populating a table of numbers, which, as...

WHOA!

Great post. Very nice solution. Scalable. That was something I honestly hadn't thought of. We were just having fun with the problem statement. But, in my, and my co-worker's, defense,...

Nice query, violated the rules though.

Nice. I like it. Simple, clean. Good job.

I wouldn't recommend passing executable strings to the database just because each execution gets it's own plan. You want the system to reuse plans. Most of the time, in most...