Viewing 15 posts - 45,781 through 45,795 (of 59,063 total)
krypto69 (1/17/2009)
The method I posted above worked...but gives me fewer records...so I'm stuck..
Heh... we are too... you've not posted the CREATE TABLE statements I asked for and you've not posted...
January 17, 2009 at 5:55 pm
Jeff Moden (1/17/2009)
TheSQLGuru (1/17/2009)
1) http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/28/poor-men-see-sharp-ndash-more-cursor-optimization.aspx. Don't forget to examine the original post mentioned at the top.Thanks Kevin, and will do.
Oh... those... I've read those before... and, I don't get...
January 17, 2009 at 5:50 pm
TheSQLGuru (1/17/2009)
1) http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/28/poor-men-see-sharp-ndash-more-cursor-optimization.aspx. Don't forget to examine the original post mentioned at the top.
Thanks Kevin, and will do.
January 17, 2009 at 4:54 pm
TheSQLGuru (1/17/2009)
January 17, 2009 at 4:53 pm
Matt Miller (1/17/2009)
Say it with me: "ricochet"....:)
Heh... DUDE! Did you just call me a hard head? 😛
Anyone remember the ol' "Ricochet Rabbit" cartoons? Or, how about "Quickdraw McGraw"...
January 17, 2009 at 4:43 pm
RBarryYoung (1/17/2009)
Hey, I just read it. That is a great article!
Awesome... thanks for looking it up, Barry. Her mastery of the written word is just an absolute pleasure...
January 17, 2009 at 4:39 pm
GilaMonster (1/17/2009)
Jeff Moden (1/17/2009)
how can you possibly think he's wrong?
Well, it's not that he's wrong. That's a perfectly correct answer, just to a different question. It's the same...
January 17, 2009 at 4:17 pm
Sergiy (1/17/2009)
Jeff Moden (1/17/2009)
January 17, 2009 at 4:11 pm
Chad Crawford (1/16/2009)
Thanks RBarry, Matt, Ramesh and Jeff. This is good stuff, and exactly what I needed.Chad
Thanks for the feedback, Chad.
January 17, 2009 at 3:58 pm
RBarryYoung (1/16/2009)
And the execution plans are a reliable indication of what SQL Server is doing with a query as long as you remember what...
January 17, 2009 at 3:55 pm
jim.riedemann (1/16/2009)
January 17, 2009 at 3:33 pm
LeeBear35 (1/16/2009)
January 17, 2009 at 3:28 pm
gints.plivna (1/17/2009)
Informix is dead, err I mean bought by IBM on 2001 😉
Heh.. a death knell for sure... anyone remember Lotus 123 or Symphony? And, if you actually like...
January 17, 2009 at 3:20 pm
Sorry... I asked the wrong question... does the target table have any data in it that you actually want to keep? If it does, then you can't get true...
January 17, 2009 at 3:08 pm
GilaMonster (1/17/2009)
Jeff Moden (1/17/2009)
the thing is that Ranking can take care of that one because you're grouping by day.
No, I'm not. A group is any number of events that...
January 17, 2009 at 3:06 pm
Viewing 15 posts - 45,781 through 45,795 (of 59,063 total)