Perhaps a simplified version of the method in the following article would do. It would also help a lot with other things you might ask of the hierarchical data.
http://www.sqlservercentral.com/articles/T-SQL/94570/
--Jeff Moden
Change is inevitable... Change for the better is not.