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

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