Viewing 15 posts - 7,696 through 7,710 (of 8,416 total)
Very nice Lutz; I believe we should now call you a 'SQL Master' 😉
Well done.
Paul
June 22, 2009 at 3:01 am
Jeff Moden (6/21/2009)
Carl Federl (6/21/2009)
Joe CelkoAck!
+1 ACK!
June 21, 2009 at 9:33 pm
It is not legal to DECLARE a cursor inside a common table expression (the WITH part). That is the cause of the specific error.
In fact the cursor is never...
June 21, 2009 at 9:29 pm
Jeff Moden (6/21/2009)
Sorry... couldn't find the world "holding" anywhere in the entire thread.
Clearly I am not having one of my more lucid days. Let me try again - after...
June 21, 2009 at 8:39 pm
lmu92 (6/21/2009)
Ok, taking the first step: Hello, my name is Lutz and I'm Threadicted.
Funny! 😀 :w00t:
June 21, 2009 at 5:07 pm
Jeff Moden (6/21/2009)
Do you have a link to the post for the "holding variable"? I want to see what you're talking about before I respond...
I was just continuing on...
June 21, 2009 at 4:58 pm
Florian Reischl (6/21/2009)
Paul White (6/21/2009)
I still don't understand what was wrong with that - please enlighten me!
You wrote url http://www.trademe.co.nz/ but a correct url requires the http://http://www.trademe.co.nz/
BTW: I chose for...
June 21, 2009 at 4:14 pm
Florian Reischl (6/21/2009)
Try your link and mine 😎
Just one more reason why database people* shouldn't mess with iframes I guess :blush:
I still don't understand what was wrong with that -...
June 21, 2009 at 3:30 pm
Jeff Moden (6/21/2009)
I agree... the word "Quirky" leaves a lot to be desired... I prefer the term...
June 21, 2009 at 2:54 pm
June 21, 2009 at 2:48 pm
ps,
That was my general understanding too.
(It also left me slightly confused - but I guess he'll be back if/when problems resurface)
Well done everyone for getting James sorted.
Paul
June 21, 2009 at 3:43 am
Jeff Moden (6/20/2009)
Oh yeah... now I remember. One column needed to be split (a portion isolated, really) from the middle.
Fascinating thread. I just spent the last couple of...
June 21, 2009 at 3:39 am
Jeff Moden (6/21/2009)
Heh... well done, Paul. You should have written the article. Thanks for taking the time.
Wow- coming from you that's awesome!
And you're welcome, of course -...
June 21, 2009 at 3:32 am
Just to add: I don't want to give the impression the SCHEMABINDING only produces benefits in UPDATE plans - it doesn't.
The key point is that the QO can...
June 20, 2009 at 10:58 pm
Long answer:
SCHEMABINDING performs no magic with simple integer math - so we don't expect a difference with the SELECTs in your example code.
Where it does make a huge difference, is...
June 20, 2009 at 10:30 pm
Viewing 15 posts - 7,696 through 7,710 (of 8,416 total)