2006-09-11

Hierarchies in SQL

I created an SQL script that demonstrates the 'interval' approach to managing hierarchies in SQL.  It is based upon approaches presented in Trees in SQL and Nested Intervals with Farey Fractions