Better off with Closure Trees (aka Closure Tables.) Start at page 48. http://www.slideshare.net/billkarwin/sql-antipatterns-strike-back http://www.slideshare.

Better off with Closure Trees (aka Closure Tables.) Start at page 48. http://www.slideshare.net/billkarwin/sql-antipatterns-strike-back http://www.slideshare.net/billkarwin/sql-antipatterns-strike...