+1, Related reading (all from Bill Karwin of SQL Antipatterns fame): http://stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-

+1, Related reading (all from Bill Karwin of SQL Antipatterns fame): http://stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree/192462#192462 http://stackoverflow.com/questions/192220/what-is-the-most-e... http://www.slideshare.net/billkarwin/models-for-hierarchical-data http://www.slideshare.net/billkarwin/models-for-hierarchical... http://karwin.blogspot.in/2010/03/rendering-trees-with-closure-tables.html http://karwin.blogspot.in/2010/03/rendering-trees-with-closu...