Aside from this current error, its funny that in writing a normal select statement in T-sql, i shouldn't even need any commas between the fields and normally i dont. i added the commas initially ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.