Viewing 15 posts - 1,786 through 1,800 (of 4,080 total)
The words 'Mississippi' and 'Tennessee' scare me slightly. Way too many repeated vowels, and a very low score for consonant-diversity!
Be kind, Paul. I still haven't learned the entire...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 19, 2010 at 6:28 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 19, 2010 at 6:04 am
Hey Paul, what got you onto a recursive kick?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 19, 2010 at 5:55 am
Speaking of time zones, it's midnight here.
Goodnight, Paul
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 11:01 pm
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. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 10:44 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 5:34 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 5:03 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 4:48 pm
Way to go, Unc.... 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 4:20 pm
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. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 12:49 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 9:18 am
(sigh) Not quite, but close.
Now I should finish my coffee and get on down to the office. Later, y'all.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 6:51 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 6:44 am
Couldn't find a good elvish translator.
They really should have one for babelfish. I would also support having a Klingon version so that Alvin can participate. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 6:42 am
Why am I unsurprised that you would have studied Sindarin, Gail?
I had a go at memorizing Tolkien's poetry once. (Which I concede is not brilliant, but then I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 6:31 am
Viewing 15 posts - 1,786 through 1,800 (of 4,080 total)