Viewing 15 posts - 46,921 through 46,935 (of 59,064 total)
Jack Corbett (11/28/2008)
If it has to be a view change the CTE to a derived table in the FROM clause.
Strangely enough, I've not tried using a CTE in a...
November 28, 2008 at 4:36 pm
Mike C (11/28/2008)
TheSQLGuru (10/14/2008)
And I too think this is a presentation layer item. Or perhaps a CLR...
November 28, 2008 at 4:34 pm
rbarryyoung (11/28/2008)
Heh. Now that sounds like the ancient art of Wi-Yi-Yotta.😛
You mean the one cherished by the "fugawie" tribe? :hehe:
November 28, 2008 at 4:28 pm
jacroberts (11/28/2008)
My original actual query was a lot different and maybe I've over simplified it for want of a simple example.
I agree and the change you made seems to...
November 28, 2008 at 4:15 pm
Chris Morris (11/28/2008)
Jeff Moden (11/28/2008)
That's about what I would expect from an almost real set of random numbers.You mean almost reel, right? 😛
-- did you catch the dupes?
Yep... and the...
November 28, 2008 at 3:44 pm
Heh... that's "Mo den e'nuff outa yous". 😛
November 28, 2008 at 3:39 pm
Oh... and I agree with both Barry and Gail as to why people took exception to both the original post and the very "pork chop" deserving replies that he made.
November 28, 2008 at 3:21 pm
Owing to a response I had given once before and that I won't replay here, the word "pork chop" has become a metaphor for setting someone straight, usually with indisputable...
November 28, 2008 at 3:18 pm
Heh... it wasn't wasted and is actually quite funny especially in reference to Toad... :PI just didn't get back to it and lost track of the thread.
November 28, 2008 at 3:03 pm
Ninja's_RGR'us (11/28/2008)
That 1M rows query only processes 95MB of data (from stats in actual plan). I was expecting some sort of...
November 28, 2008 at 9:24 am
Hugo Kornelis (11/28/2008)
Yes, I agree... you cannot rely on anything other than an OrderBy on Select statements.
And, yes... I believe that everyone knows that "deprecation" comes with plenty of warnings...
November 28, 2008 at 9:21 am
Hey folks... I've got outside "obligations"... I probably won't be able to return to this for a while. Keep focused... we need to find out why the system jacRoberts...
November 28, 2008 at 9:03 am
Jeff Moden (11/28/2008)
Let's start out with one of my previous requests:
1. What is the CPU, Ram,...
November 28, 2008 at 9:01 am
Wow... now that's interesting. We need to find out what the differences are...
Let's start out with one of my previous requests:
1. What is the CPU, Ram, Harddrive, etc,...
November 28, 2008 at 8:53 am
jacroberts (11/28/2008)
Joe Celko (11/28/2008)
You build a look-up table once (and if you did a proper calendar table, you also benefit from other uses)....
November 28, 2008 at 8:43 am
Viewing 15 posts - 46,921 through 46,935 (of 59,064 total)