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 ...
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 ...