Viewing 15 posts - 3,586 through 3,600 (of 4,080 total)
Could we see the fully generated string please? Preferably, one generated with a print statement right before statement 99 where the error occurs.
However, I'm pretty sure Florian's right....
__________________________________________________
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 5, 2009 at 8:58 am
Corrected version. Still runs in a millisecond or less.
;WITH
L0 AS (SELECT 1 AS C UNION ALL SELECT 1),--2 rows
L1 AS (SELECT 1 AS C FROM L0 AS A,...
__________________________________________________
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 5, 2009 at 8:15 am
My bad.
I skimmed over the part that said nothing could be created in the DB. I was trying to poke fun at Jeff because he...
__________________________________________________
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 5, 2009 at 8:11 am
Thanks for the reply. It's always good to know what the resolution was. I sent you that last example because I believe it will work...
__________________________________________________
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 5, 2009 at 7:51 am
JEFF !!!! You don't have a tally table available?
select dateadd(yy,datediff(yy,0,getdate())-5,0)+ N-1
from dbo.tally
where N < datediff(dd,dateadd(yy,datediff(yy,0,getdate())-5,0),getdate())+2
Runs almost a full millisecond faster at 5-10 years. 😉
Pretty much a...
__________________________________________________
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 5, 2009 at 7:46 am
(1) We can't see your list of tags... please post them as an attachment.
(2) I'm not sure why you feel the need to store the tags. ...
__________________________________________________
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 5, 2009 at 7:29 am
I guess SOMETHING did.
__________________________________________________
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 5, 2009 at 7:21 am
Deleting your posts strikes me as the equivalent of the people who disconnect from losing positions in online chess games. It's the equivalent of kicking over the...
__________________________________________________
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 5, 2009 at 7:11 am
Great minds think alike. I'm just happy that I'm not the only person on earth who might remember that song. 😀
__________________________________________________
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 4, 2009 at 2:53 pm
ARTIST: Tom Lehrer
TITLE: Lobachevsky
Lyrics
Who made me the genius I am today
The mathematician that others all quote
Who's the professor that made me that way
The greatest that ever got chalk on his...
__________________________________________________
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 4, 2009 at 2:21 pm
try to order the list of values so that the most frequently found values are placed first
Grant, I've read somewhere a while back that this is actually...
__________________________________________________
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 4, 2009 at 11:16 am
I'm glad you said that, Gail. I did a single test on that a while back because I figured the internal logic had to be the same, but...
__________________________________________________
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 4, 2009 at 10:53 am
Having spent my lunch hour perusing his blogsite, it's very tempting to do a parody of it, but we've already spent more time unloading on him than he's worth. ...
__________________________________________________
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 4, 2009 at 10:47 am
Some other priceless pearls from the "Mangled" SQL Blog....
5. Avoid using SELECT * FROM when only a few columns are needed. Try to specify each column.
How about avoiding using SELECT...
__________________________________________________
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 4, 2009 at 10:31 am
You have to admire the courage of his convictions... Deleting his own posts so that people won't throw his own words back at him?
Perhaps someone should...
__________________________________________________
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 4, 2009 at 9:08 am
Viewing 15 posts - 3,586 through 3,600 (of 4,080 total)