If you have time to do a little testing, it might be interesting to see the performance difference of this approach against your current code. I understand some...

What? We didn't so much as mention RBAR. I know that for a fact or otherwise Jeff Moden...

Steve, I was the one thanking you 😉 and certainly almost everyone feels the same way.

From the responses, I think it's safe to say that your top people would not...

No complaints from me, Paul. I only hope Trans54 came back to read your first post.

Thanks to you all for the feedback. Plainly the vast majority perceive this as blacklisting. So, out of immense respect for you all, I will...

We host systems for a number of clients, but they all have separate DBs and so we can set up their tables differently. (Or you can give them...

Not really improvements, just extensions of the concept.

For example, instead of [holiday], someone might have [Holiday_US], [Holiday_Canada], and [Holiday_Mexico]for multinational support. I've also seen calendar...

Flo: We learn from each other. It's always a pleasure to tackle problems with you.

By the way:

Argh! I'm...

Be my guest Flo. 🙂 By a calendar table, I actually meant a table other than a tally table, which would list weekend days and holidays....

Will anything ever begin or end on a Sunday?

Although it looks as if you have an answer for your query now, be advised that case is an expression, and as such can only return a single value. ...

Do you take holidays into account at all? If so, you might be better served by creating a calendar or holidays table. Let me...

Something amiss here. I see only threads in which this person has participated, not originated....

Gail, I simply have to reply to the following:

For me to indicate that a person is not...

David, I'm sure people would stick me on that list along with you. 😉

Yes, Lynn, I've always seen the desert as a place of spiritual retreat for you.

I've looked...