Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I do ___________ with a Hierarchical structure?
Database Design
How!?!? Read up on the subject!! 
Links to other sites:
[link http://www.sqlteam.com/item.asp?ItemID=8866]More Trees & Hierarchies in SQL[/link]
[link http://www.intelligententerprise.com/001020/celko.jhtml]Trees in SQL[/link]
[link http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.htm]Versatile High Performance Hierarchies in SQL Server[/link]
[link http://www.dbazine.com/tropashko4.shtml]Trees in SQL: Nested Sets and Materialized Path[/link] (highly technical)
[link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/recursion.asp]SQL Server Magazine January 2001: The Zen of Recursion[/link]
Tek-tips thread:
[link http://www.tek-tips.com/viewthread.cfm?SQID=864808&SPID=183&newpid=183]T-SQL to establish hierarchy[/link]
Links to other sites:
[link http://www.sqlteam.com/item.asp?ItemID=8866]More Trees & Hierarchies in SQL[/link]
[link http://www.intelligententerprise.com/001020/celko.jhtml]Trees in SQL[/link]
[link http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.htm]Versatile High Performance Hierarchies in SQL Server[/link]
[link http://www.dbazine.com/tropashko4.shtml]Trees in SQL: Nested Sets and Materialized Path[/link] (highly technical)
[link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/recursion.asp]SQL Server Magazine January 2001: The Zen of Recursion[/link]
Tek-tips thread:
[link http://www.tek-tips.com/viewthread.cfm?SQID=864808&SPID=183&newpid=183]T-SQL to establish hierarchy[/link]