Dear Robvolk
May 11, 2006robvolk, 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...:)