Viewing 15 posts - 34,066 through 34,080 (of 59,102 total)
I [font="Arial Black"]really [/font]like the point of this article whether or not it's been illustrated using a problem that's been done many times or not. Heh... and if Google...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2011 at 6:58 am
Solomon Rutzky (5/1/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 8:30 pm
Thanks, Remi... sorry for the snap...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 8:10 pm
... and, no... smiley faces don't usually work for me. I don't even see them most of the time. I've been burned pretty badly by some folks who...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 7:43 pm
Heh... you did relate me to Celko and there was no smiley face on that line.
Sorry, Remi... I'm a bit on edge and I took your humor the wrong way.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 7:39 pm
Peter,
What does the following snippet from your code do?
,1 S SeqID FROM ...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 7:30 pm
Ninja's_RGR'us (5/3/2011)
Jeff Moden (5/3/2011)
SwePeso (5/3/2011)
See this topic. We hammered the subjet to death...
BWAAA-HAAAA!!! With only 55 rows of test data on one hand and only 8788 from the "Adventureworks"...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 7:25 pm
SwePeso (5/3/2011)
See this topic. We hammered the subjet to death...
BWAAA-HAAAA!!! With only 55 rows of test data on one hand and only 8788 from the "Adventureworks" hand, I'd have...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 6:58 pm
tfifield (5/2/2011)
This should give you what you want. It gives each order and its items for only orders that have the same items.
; WITH CTEItems AS
( SELECT oid, itemid
,...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 6:48 pm
ChrisM@home (5/3/2011)
Here's another version using APPLY without any sneaky tricks.
Chris, run an estimated execution plan of your code against the following 10,000 rows of data and look at the row...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 6:28 pm
Thanks for the feedback, Shannon.
When you say...
One situation I would like to see if it can be solved, is I wrote a script that will search my database char columns...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 5:48 pm
gary.rumble (5/3/2011)
It is thus:
Outstanding. Time for some more tests at the Moden house. Thanks, Gary.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 5:40 pm
WayneS (5/3/2011)
Oh Jeff... looks like the Perm0Based is beating your newest, hottest code! (Man, I love it when the community comes together like this!)
Very cool and absolutely correct. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 5:38 pm
Goldie Lesser (5/3/2011)
Eagerly awaiting the varchar(max) versions so I can incorporate them into my databases. 🙂
Does anyone have a theory as to why the CTE...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 5:31 pm
Nadrek (5/3/2011)
WayneS (5/3/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2011 at 5:28 pm
Viewing 15 posts - 34,066 through 34,080 (of 59,102 total)