Viewing 15 posts - 33,046 through 33,060 (of 59,102 total)
s.khann786 (7/31/2011)
i want to calculate parents id which have both child left and right.
this is my table.
id, parentid, left_child, right_child
1 1 ...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 31, 2011 at 7:24 am
TRACEY-320982 (7/30/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2011 at 10:22 pm
If it's a simple count of pairs you want, just look at your data for the answer. Just count all rows that have both a LeftID AND RightID greater...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2011 at 10:14 pm
There's another thing to consider. IIRC, both INTERSECT and EXCEPT essentially do a NULL = NULL comparison without any special considerations. If such a thing is required by...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2011 at 8:42 pm
ALZDBA (7/30/2011)
Normally Jeff always test stuff 😉
I certainly blew a pork chop bone out of my nose on that one. :blush:
He must have the shivers experiencing all these...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2011 at 6:33 pm
Gianluca Sartori (7/30/2011)
Jeff Moden (7/29/2011)
Gianluca Sartori (7/29/2011)
I'm inaugurating my "Vote for Jeff" signature. 😎
BWAA-HAAAA!!!! VERY cool, Gianluca. And, Uncle Sam is my favorite patriotic character to boot!
The only...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2011 at 4:45 pm
Heh... understood. Someday, we'll have to sit down, have a beer or two together, and I'll try to explain it all. It won't change your mind (nor do...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2011 at 2:10 pm
opc.three (7/29/2011)
In this case, sure, I am up for defending a decision like this. It may be unappealing, but after thinking it through I don't have a problem with it.
Understood....
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2011 at 12:48 pm
varun_2003 (7/30/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2011 at 8:19 am
varun_2003 (7/29/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2011 at 7:15 pm
PaulB-TheOneAndOnly (7/29/2011)
Sean Lange (7/27/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2011 at 6:37 pm
Orlando, can you honestly say that the format of a date stored in a database should actually matter for a user that's apparently set to writing queries against something that...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2011 at 6:26 pm
Heh... also... why on Earth does it have to be a "single query"? You doing something for a contest or what? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2011 at 6:09 pm
ranuganti (7/29/2011)
I have this type of ASCii characters in the column how do i find all in a single query other than [font="Arial Black"]alphanumarics[/font].
Let's peel one potato at a time......
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2011 at 6:08 pm
opc.three (7/29/2011)
Why do you insist on using T-SQL to turn SQL Server into a sys admin scripting platform when there are better tools out there to do the job?
Because it...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 29, 2011 at 6:01 pm
Viewing 15 posts - 33,046 through 33,060 (of 59,102 total)