Dird (4/22/2013)
ScottPletcher (4/22/2013)
unless you use cursors, and nobody wants thatAnd you think that solution isn't implicitly using cursors?
Edit: But yeah, it's a better way of doing it 😛
Dird
There's no cursor in his solution. Are there engine internal execution loops based on the internal objects of the plan? Ask Microsoft, but everything in a PC loops eventually. Is it a cursor? Most definately not.
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