Like I said before, when Jeff speaks - I listen.

Excellent article, Jeff! If this article was a "tsql how-to" in Barnes & Noble, I would buy it.

All I can say is that when Jeff talks, I tend to listen. Thanks for the post, Jeff.

The procedure is syntatically correct. The mistake is in not telling us what error you are receiving.:unsure:

Awesome! I could not get the right case statement.

Thanks for your quick response Eugene.

I would certainly be interested in a before/after solution. The fact that you took Jeff's response and solved the problem yourself is quite a testament to your tenacity.

And, if you...

Ahhhh...that's why you call us McNewbie's. 🙂 Great site, and great editorials. Look forward to seeing them every day.

I was sure I had the correct answer based on the question in the email...but when I linked to the site I saw another question - "What is the output...

This was a great question. I just added "The Logical Query Processing Diagram" to my toolkit. Thanks for the link.

Since you mentioned "new system"; from a development point of view, you might take a look at any changes in SQL stored procedures for the application. For instance: are any...

You're welcome! It gave me a headache one day trying to debug an application, so I thought I'd post the question.

I've learned a great deal from this forum. It's amazing...

We had a .Net application that kept getting a null reference returned from a stored procedure. Since SCOPE_IDENTITY() was used after the INSERT, we assumed the value was OK until...

As a frequent forum visitor, the responses to this topic hit a cord.

We utilize Usage Based Pricing with our web-based timesheet application, with a twist.

1) We only charge...