patelmohamad (11/26/2010)
HI,Avoid Cursor , Using While loop
No insult intended but that's just not good advice. A good FAST FORWARD, READ ONLY, STATIC cursor is nothing more than a Temp Table and a While Loop. They both have the same performance and they both use nearly identical resources.
Now, if you said "avoid RBAR", I'd be right with you. 😉