Or Alabama?

Be kind, Paul. I still haven't learned the entire...

Congratulations Paul, on winning the coveted 13K award!!

I'm thinking we should all agree on November 18th being recognized as Thread Day.

I'm in Oxford, Mississippi, actually, about an hour south of...

Hey Paul, what got you onto a recursive kick?

Speaking of time zones, it's midnight here.

Goodnight, Paul

Neither the code nor the execution plan are pretty, but this will get it done.

No guarantees on scalability, but it's late and I'm off to bed. ...

My error. I took the pseudo code too literally. How about just growing the WHEN clauses like this? I know it's tedious to have...

First thing you must understand is that CASE is an expression not a statement. All it does is return a value, like a function with IF/THEN logic embedded...

You will find yourself getting a LOT of table scans using that approach. It is almost unavoidable given that you are going to be searching for strings LIKE...

Way to go, Unc.... 😀

Hey Blackhawk:

The problem he was running into was that the optimizer had no statistics on an indexed temporary table he was joining and so it was making bad choices. ...

For the future, if you ever run into an instance where you have to execute a stored procedure multiple times, instead of calling a function, you might also consider dynamic...

(sigh) Not quite, but close.

Now I should finish my coffee and get on down to the office. Later, y'all.

A Elbereth Gilthoniel

Silivren Penna Miriel

Enna Aglar Elenath

Gilthoniel, a Elbereth

We remember, we who dwell

In this far land, beneath the trees

The starlight on the western seas.

Okay, at least a few aged...

They really should have one for babelfish. I would also support having a Klingon version so that Alvin can participate. ...