autoexcrement (7/28/2014)
Even with the...
AND CTE1.item = CTE2.item
...in the join?
It seemed to work okay. Did I screw something up?
Hrm, good point, my apologies. I read it too quickly. Habit on my part to make sure I don't screw up the partitioning versus the ordering, but it works both ways.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA