I am in an environment that during code review, if I ever write a stored procedure that uses a cursor, the reviewer always says, "Oh! Uhoh! Cursors are bad unless they are absolutely neccessary." Then ...
Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...