Viewing 15 posts - 57,736 through 57,750 (of 59,054 total)
Yap... we've all written "those"... see the update I just posted to my previous message...
September 4, 2006 at 3:23 pm
Sure, Remi... thanks for the interest...
Personally, I think triangular joins should never be used because it's an absolutely insane form of RBAR (a "Modenism" for "Row By Agonizing Row"). Here's an example...
September 4, 2006 at 3:09 pm
| Update B : It is a base table problem. I'm still using your code above though. Very useful. ... |
September 4, 2006 at 1:02 pm
X/2 records is the difference ![]()
Not sure why Mark thinks one is necessary here even with his latest explanation. Still trying to figure it...
September 4, 2006 at 12:58 pm
I guess I don't have enough information... first, I'm not sure why you need this...
join Number_list n
on n.number < t.Person_count --This makes a triangular join!!!
WHERE n.number < @Max_person_count
Second, are...
September 4, 2006 at 11:55 am
Richard,
Each instance of CASE must have an END... You have 3 instances of CASE but only 1 END. That would be the problem.
However, the other guys are right... in this...
September 4, 2006 at 11:00 am
Here's one way... nasty fast... takes 60-123 milliseconds for 11,000 rows (more than 30 years worth of dates if needed) and 5.8 to 9.2 seconds for a million rows (if TempDB doesn't need to...
September 4, 2006 at 10:53 am
You bet. Tuan... thank you for the feedback...
September 4, 2006 at 10:02 am
Thanks Trystan,
Looking back at it, one of the CASE statements is simply overkill... replacing this part should also work with a tiny bit more speed...
--===== Determine the rest...
September 4, 2006 at 9:21 am
I don't know what I'm missing on this for you... I'll check with my network guys on Tuesday. Sorry I wasn't able to help you without getting help myself
September 4, 2006 at 8:39 am
September 3, 2006 at 9:58 pm
Just a bit of clarification... I've not tested WHERE NOT IN vs OUTER WHERE NULL on sp4... I've seen several differences in execution plans between sp3a and sp4...
September 3, 2006 at 9:41 pm
It would usually be someone who has a role of "Domain Admin" (I think that's what they call it but not sure... I'm not a network type of guy).
September 3, 2006 at 9:38 pm
Viewing 15 posts - 57,736 through 57,750 (of 59,054 total)