Hugo Kornelis (9/12/2016)
That isn't actually what you *said*, though? You said that a (well written) cursor will never, ever beat a WHILE loop, which implies the WHILE is faster?
Typical case of PEBKAC. (Or in this case, PEIMB - problem exists in my brain)
After reading dbishop's last reply I double checked my post and **still** managed to overlook the logic error. It was only after reading your explanation that I started to slap my forehead. (Which reminids me that this forum really needs a *facepalm* smiley)
Oh, and Ron: You are right in general, and in my specific case as well because I am indeed not a native English speaker, but in this case the problem really was me not seeing how I had accidentally misplaced the two terrms.
So yes, I mistyped my original reply. What I should have written was "a WHILE loop, no matter how well written it is, will never ever beat a (well written) cursor".
Sorry for the confusion.