Hmm... interesting, I am glad I solved your problem

At work, we are still using SQL Server 2005, we will soon upgrade to 2012, and I can't wait to learn the new features.

Normally, when I do hierarchy trees, I put in the child the parent ID, this way, I can use CTE recursion (the "with" keyword), and find parent, children, etc...