This was markdown testing, or the code and explanation is incomplete. Since this was just as task I had to do in test a I did not expand since there was not many interesing or specific data connected ...
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 ...