Viewing 15 posts - 49,516 through 49,530 (of 59,078 total)
It's ok... the ORDER BY's don't hurt anything and they both make it very obvious to the reader what's happening. That can be worth it's weight in gold when...
June 29, 2008 at 7:58 pm
fisher08 (6/27/2008)
Its the partners specs not ours, we are working for them in a way or else they will go elsewhere...that's why don't ask why...:)
In that case, I'd ask "Why"...
June 29, 2008 at 6:34 pm
True enough... I kinda like @Days, though... makes the CTE easier to read from a self documenting aspect. Yeah, I know... easy to read anyway. 🙂
June 29, 2008 at 6:25 pm
Actually, no Order By is really necessary except to satisfy the syntactical requirements of Row_Number()...
For example...
[font="Courier New"]SET STATISTICS TIME OFF
SET STATISTICS IO OFF
PRINT REPLICATE('=',100) ---------------------------------------------------------
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
PRINT '===== Jeff Moden''s...
June 29, 2008 at 6:01 pm
Similar error as to what someone recently did with dates 😉 Check the final value of @BitBucket on Matt's...
June 29, 2008 at 5:47 pm
rbarryyoung (6/29/2008)
Hey, did you get a chance to look at that draft yet?
Barely... I did a quick scan and now I need to do a full read...
June 29, 2008 at 5:41 pm
gerald.duncan (6/29/2008)
June 29, 2008 at 5:33 pm
... and, come to think of it... I think 1 Order By in the CTE will probably be enough, as well. 😉
June 29, 2008 at 5:30 pm
Much better... now, with the TOP in the CTE, do you really need the WHERE clause?
June 29, 2008 at 5:28 pm
john.henderson (6/29/2008)
whether the set has one member or a million doesnt matter - handle the whole set.
That's step 1 to perfect set based thinking... glad to see someone else believe...
June 29, 2008 at 5:26 pm
Search the following article for "Dozens of Other Uses" and look at the first script after that... correctly applied, it's the answer to your problem...
June 29, 2008 at 5:22 pm
It's a challenge only if you can't get people to listen... I couldn't get them to listen the first time either... then, I took a 24 hour process that would...
June 29, 2008 at 5:19 pm
TRACEY (6/29/2008)
June 29, 2008 at 5:15 pm
dfalso (6/29/2008)
So now, what's the minimum number of rows guaranteed to be in master's syscolumns?
Like Barry said... there's always at least 11,000 rows even in a brand new installation. ...
June 29, 2008 at 5:09 pm
rbarryyoung (6/29/2008)
Any of this cow left for me? 🙂Here is my entry (really just a tweak of Jeff's):
Nicely done, Barry... but I get numbers just a bit slower (not...
June 29, 2008 at 5:08 pm
Viewing 15 posts - 49,516 through 49,530 (of 59,078 total)