Re: Nested set model with large gaps and spreads in the numbering

>> For some reason, what you are trying to do reminds me of the
process of
defragmenting a disk. <<

Good thought!

Richard Romley sent me a recursive UDF that computes the new left value for a node. It can be put into one statement then used in   UPDATE Tree

     SET lft = ShiftLeft(left),
         rgt = ShiftLeft(left) + (rgt-lft);

Very neat. I have to go out of town, but I will post it when I get back. Received on Tue Sep 17 2002 - 08:39:05 CDT