polkadot (2/23/2013)
I’m working on the hierarchy lesson in Ken Henderson’s The Guru’s Guide to Transact-SQL.
I'd like to recommend a different approach to hierarchies. Please see the following 2 articles. And I guarantee the code in the articles works.
http://www.sqlservercentral.com/articles/Hierarchy/94040/
http://www.sqlservercentral.com/articles/T-SQL/94570/
--Jeff Moden
Change is inevitable... Change for the better is not.