Is there a specific reason you can't use Celko's Nested Set Model? I haven't yet found anything faster or better than that...
-Cameron ----------------- Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] > -----Original Message----- > From: Thomas Eppler [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 29, 2002 4:49 AM > To: SQL > Subject: Trees ... > > > Hello alltogether > Does anyone of you have "the best" solution for getting a tree > structure out > of a table by using only one query? > I mean a simple tree structure only using a Parent-ID - and not a tree set > up by using graph theory (e.g. see > http://www.intelligententerprise.com/001020/celko.shtml) > > I still use this CF_tree-Tag, but with bigger amounts of data it gets very > slow. > So what I need is a quick SQL statement which gets me the nodes on level 1 > sorted by data and all the other nodes sorted by ID (so the logical > structure keeps alive). > > Also as I saw in the manual, there seem to be functions within > Transact-SQL > which deal with tree structures ... > > Any hint or idea will be appreciated - also general hints on how to handle > tree structures ... to be honest for years I am looking for > better solutions > .. > > Regards > Thomas > http://www.internetmanagement.ch > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
