Viewing 15 posts - 8,296 through 8,310 (of 8,416 total)
Florian Reischl (4/17/2009)
Chunks? Your suggestion was to get all in one XML.Flo
You gave my suggestion a much deeper analysis than it warranted 😉
By 'chunks' I meant something like a TOP...
April 18, 2009 at 5:40 am
Jeff Moden (4/17/2009)
Paul White (4/17/2009)
Why not? You're the one speaking in absolutes. 😉
Yes. That was the humourous part (YMMV on that).
April 18, 2009 at 5:29 am
Jeff Moden (4/17/2009)
"Better SQL" should also include better, faster, and more correct functionality in the database engine itself...
Agreed. MS should direct most of their effort to the core product....
April 18, 2009 at 5:17 am
Jeff Moden (4/17/2009)
April 18, 2009 at 4:59 am
steve dassin (4/17/2009)
I agree. Learning something new is just a form of grandstanding. It's a crutch for people who really haven't mastered what their already using 🙂
Hey Steve,
Just so you...
April 18, 2009 at 4:55 am
Charles Kincaid (4/17/2009)
OK, I know that using the CLR...
April 18, 2009 at 4:47 am
Perl.NET :pinch:
Now that was funny.
Night all!
April 17, 2009 at 8:37 am
Flo!
Yes it's getting late - and I have an appointment with the dentist early in the morning...eeek!
Resource problems? Well maybe, but we could always process the XML in appropriate...
April 17, 2009 at 8:32 am
Hey Flo!
I'm surprised no-one has suggested sending the entire text to split to a CLR function in an XML parameter, generated from a SELECT with some kind of FOR XML...
April 17, 2009 at 7:28 am
Hey Mithin,
That was just a bit of fun though on my part - I hope that was clear!
I sometimes use = ANY rather than IN, just for variety 😀
Paul
April 17, 2009 at 5:50 am
Derek Dongray (4/17/2009)
April 17, 2009 at 5:45 am
Mithun
I have one query likeselect * from emp where dept_no in(10,20,30)
Can anyone help me in using EXISTS instead of IN ?
Mithun,
Everyone else has posted the sensible answers, so I won't...
April 17, 2009 at 5:19 am
Jeff Moden (4/16/2009)
Heh... nope... now that I understand what you mean, not necessary. I was just getting whiplash between the words "elegant" and "brute force". 😀
I see what you...
April 16, 2009 at 8:05 pm
Jeff Moden (4/16/2009)
Paul White (4/16/2009)
3. A tally solution remains an elegant, if somewhat brute-force, solution.
Thanks for the confidence on the book, Paul. I am curious though... you keep...
April 16, 2009 at 7:56 pm
Jeff Moden (4/16/2009)
April 16, 2009 at 7:35 pm
Viewing 15 posts - 8,296 through 8,310 (of 8,416 total)