View Single Post
  #8 (permalink)  
Old June 12th, 2008, 07:54 AM
planoie's Avatar
planoie planoie is offline
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Old Pedant-

What happens when you need to move a node of the tree structure? There's a bit of work involved with recomputing child nodes if you are storing discreet paths in each.

SQL Server 2005's Common Table Expression capability is rather good at dealing with recursive structures.

-Peter
compiledthoughts.com