>> 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 - 08:47:15 CDT
