I haven't taken the time to dissect your code, but I did want to write my thoughts when it came to attacking set-based vs. structured programming.

Most traditional structured languages are...

For what it's worth, I come from a structured programming and OOP background myself (mostly VB, VB.NET, ASP.NET, etc.).

But when it comes to SQL and set-based programming, I take a...

You don't give very much information to work with. What do the queries look like? And how big are the data sources?

Give us some detail, and we might...

I found this article profound to the point that I forwarded it to my wife.

Going the extra mile will only help you out in the long run.

Great article. I've long argued that "if you want to get anywhere in life, you have to step out of your comfort zone."

This is painful to read. Can you post an example (a small sample should suffice) of what the output should look like? You'll probably get more responses that...

Ummm . . .

http://technet.microsoft.com/en-us/library/bb510427.aspx

:angry:

Am I missing something here?

Not sure whether or not this is applicable, but this sounds similar to the scenario presented in an article I read here a few weeks ago.

Here's the link to the...

Okay, good to know. I'll definitely keep that in mind. Thanks!

Okay, for anyone who cares, I just discovered one difference . . .

SELECT allows me to do this:

select @ErrNo = 0, @ErrMsg = 'error message'

However, when I try this (with...

Add me to the growing contingent who protests the answer.

I got . . .

2009-11-16 10:37:19.917

2009-11-16 10:37:19.930

2009-11-16 15:37:19.930

2009-11-16 15:37:19.930

Looks like it's FALSE to me!!!