I just read a great article on this (found via fullasagoog): http://www.sitepoint.com/article/hierarchical-data-database
Don't be put off by the 'php/mySql' tag - the concepts apply to this situation perfectly. The article covers the 'Adjacency List' and 'Modified Preorder Tree Travel' models. HTH Antony On 11/15/06, Duane <[EMAIL PROTECTED]> wrote: > > Is it possible to create a recursive query in SQLServer? > > I have a table that contains a parent/child record relationship and I want > to build a tree without client side processing. > > ID Parent > 1 Null > 2 1 > 3 Null > 4 2 > 5 1 > 6 Null > 7 2 > 8 6 > > Needs to be sorted as > -1 > - 2 > - 4 > - 7 > - 5 > -3 > -6 > - 8 > > > TIA, > Duane > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2624 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
