Yes.  It sounds to me that you're using the "Developer" Edisition to do "production work"... which goes against the licensing...

It would be easier if the first row were numbered "0" instead of 1 so that we could use modulo all by itself to do this but, it can still...

@jeffmoden  I have not spent much time on SSC for a good few years.  Searching for something else, I came across this article (and the follow up) written by...

Hi, excellent post, I have taken it and put it into practice, and it works very well for me to redo the whole nested set, But I want...

Just to ask the question, I haven't tested any of the solutions and so this question is directed at Reh23 ...

Do any of the solutions, so far, do what you...

First of all, please stop posting graphics for the test data.  See the article at the first link in my signature line below for why and one method for...

Your other post is on an SQL Server 2022 forum.

Just to be sure, I would never obfuscate numeric data.  If it's worth protecting, it's worth being properly encrypted.

Hi SSC team,

I wanted to leave the answer here just in case anyone else needs it. This works. Only caveat is that you need to use dts.vaiables...

I use IIF a whole lot to replace the longer CASE expression in CROSSTABs.  It just makes for shorter code when there are only Yes/No conditions.

I have used some of...

First of all, please stop posting graphics for the test data.  See the article at the first link in my signature line below for why and one method for producing...

Just to be sure... you're in an SQL Server 7/2000 forum... which release of SQL Server are you actually using?

And, yeah... It's really important because there's a whole lot missing...

Hi SSC team,

I wanted to leave the answer here just in case anyone else needs it. This works. Only caveat is that you need to use dts.vaiables instead of...

thx jeff.   eventually i did do the divide and conquer thing.  it took the query down from 6 minutes to 19 seconds.   i turned it over in that state...

Shifting gears to the dark side, it may be that the query was written in such a fashion that the optimizer just can't figure out if an index would help...