Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CoTuDo
Starting Member
3 Posts |
 Posted - 2006-05-11 : 07:47:35
|
| robvolk, you've posted an article about trees and hierarchies: http://www.sqlteam.com/item.asp?ItemID=8866 but I couldn't find the second part of it, and I need a move up and down procedure for my tree. My tree is built with table :tree(treeNodeId,parentNodeId,sortOrder)the third column: sortOrder it's for sort the tree, to have the possibility to move up and down...but i still can't realize it...please help me...:) |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-05-11 : 11:39:20
|
| Part II never materialized..-ec |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-05-11 : 15:49:40
|
| cross posthttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65941 |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-05-11 : 18:28:53
|
| If you are using SQL Express, then you can write recursive SQL statements pretty easily using a simple ID/ParentID structure in your table. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-05-12 : 09:00:51
|
| Sorry about that, I was looking for some articles that Corey (Seventhknight) wrote that covered the things you're looking for, but the links he posted aren't working anymore. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-05-12 : 12:03:15
|
| I found Corey's articles in the wayback machinePart I http://web.archive.org/web/20050309120528/http://www.seventhnight.com/treestructs.aspPart II http://web.archive.org/web/20050222080930/http://www.seventhnight.com/treestructs2.aspPart III http://web.archive.org/web/20050222160727/http://www.seventhnight.com/treestructs3.aspThese pages take some time to load, so be patient.EDIT:I just noticed that the forums treat the links a little weird. You'll have to copy/paste the full URLs into your browser to get it to work. -ec |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-05-12 : 14:33:59
|
also here: http://www.thesitedoctor.co.uk/seventhnight/treestructs/Thanks to Tim (timgaunt)I will get my site back up one day...  Corey Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."  |
|
|
|
|
|
|
Dear robvolk