A reader's solution for expanding hierarchies builds on the information that SQL Server Books Online provides.