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

The values in the table are basically a tree, where each node has a parent node (or NULL it it's at the root). The values are not inserted in any particular order, but the children point to valid ...