Thread: Inserting into a hierachy (nested set model)
View Single Post
  #2 (permalink)  
Old 10-29-09, 14:31
Wim Wim is offline
Registered User
  
Join Date: Nov 2004
Posts: 1,159
Quote:
Joe Celko does it in his book "Trees and hierachies in SQL for smarties".
I'm no smarty, so I haven't read his book.

Can you give an example dataset before and after, so I can figure out what you want?
__________________
With kind regards . . . . . SQL Server 2000/2005/2008/2008 R2 Earned beers: 13
Wim
Beware of bugs in the above code; I have only proved it correct, not tried it. -- Donald Knuth
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
Reply With Quote