SQL Server row looping

Here is two very useful links on Cursors

Always worth reading.
1) How to avoid Cursors
2) Cursor optimizatioin
3)Cross Apply Vs Outer Apply