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

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 17 Sep 2002 06:47:15 -0700
Message-ID: <c0d87ec0.0209170547.116289a_at_posting.google.com>

>> Below is some T-SQL code, tested on SQL Server, that implements
this followed by a few examples. The code might appear a bit complex on a first pass but the algorithm is straightforward. Note that while iteration is used, no temp tables or extra columns are required. <<

I am out of town today, but I will play with this when I get back. Looks like a lot of the same stuff that Richard Romley got, but he used recursion in a UDF instead of iteration to get the results. Received on Tue Sep 17 2002 - 15:47:15 CEST

This message: [ Message body ]
Next message: David Cressey: "Re: The Practical Benefits of the Relational Model"
Previous message: Lauri Pietarinen: "Re: The Practical Benefits of the Relational Model"
Maybe in reply to: David Cressey: "Re: Nested set model with large gaps and spreads in the numbering"
In reply to John Gilson: "Re: Nested set model with large gaps and spreads in the numbering"
Next in thread: David Cressey: "Re: The Practical Benefits of the Relational Model"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message