RE: Comparing cursor vs. WHILE loop performance in SQL Server 2008
I can't imagine a scenario where I should be using a cursor (e.g. iterating through a set of records) where I'd use a while loop, any potential performance gain (dubious at best in my opinion), would be totally offset by an increase in complexity and fragility.
Try to use a set based approach instead of a cursor is fine, a while loop?. Barking mad.....