I'm from Mississippi, Jeff. Our phone numbers are only 5 digits long. ...

🙂

Henk:

Look up sp_rename in SQL books online. Before renaming a column, check dependencies to see if you have any views, stored procedures, functions, etc that might depend...

Looking at the schema, and I use the term loosely, of your input table, I assume you are pulling this from a spreadsheet and that you won't have hundreds of...

Talk about a photo-finish. 😛

I set up a test against one million rows, run 100 times with half the numbers being negative. (The code for the...

John, I'm NOT absolutely sure, having seen your numbers. I would have expected CASE to be less code, basically a single "if". But the...

Paul, I am drawing on the experience that oftentimes a precalculated date or calendar table produces faster solutions than doing DATEADD,DATEDIFF on the fly. It would seem...

Something to ponder.

This thread has also made me broaden my horizons about tally tables. Why should there be just one flavor? If...

Hey Paul, this thread may be the motivator for me to finally learn that awful note (pun) of a language. But it also convinces me that CLR isn't...

Jeff: Just a hair slower than you guys... on my laptop at least.

Hard to isolate because of other processes, but it seems to be about...

Flo and Jeff, I just had to try.

This beast features double-barelled carburetors.... errrr tally tables.... one with two columns, and nested CROSS APPLYs.

Can you help me...

I'm about to test my only thought on the matter. If it seems to perform well, I'll send it to you.

Flo:

After following the Tally thread, there is no way I can claim to be your mentor. However you are welcome to any little tips or techniques I...

Jeffrey is absolutely correct.

Because the date test appeared late in the WHERE clause, I assumed that there wasn't an index over the date(s).

(Don't ask...

If the white space is to the left, why aren't you searching where clientcode like

%LC157790%