Length (it should actually be [interval] thickness rather than length - My bad on the naming) weighted average is calculated like this;

((Prev.MBit * Prev.Length)

+ (Cur.MBit * Cur.Length)

+ (Nex.MBit * Nex.Length))

/(Prev.Length...

I'm not sure what you mean by bound by. If you mean that I can join the table to it's self like this

FROM ##TEMP CUR

LEFT JOIN ##TEMP PREV

ON...

The table I'm working with is acutally a temporary table I've created from the source data which has been quite processed to get it to this point.

The table definition below...

Ah. I should just mention that in the assembled intervals PNG the 2nd example is a case where there would be recursion. The first three records would be...

FYI...

The total time for my process now has gone from ~ 4:30 to ~ 1:00!

Now that's performance!

I've got it!

The problem was in the order of the set statements.

Because @currrange_start and @currrange_end rely on the value of @currfile, setting @currfile to the value of the current record...

Apparently the answer is in the details. Thanks again for spending time on this. Unfortunately, it's still not quite there.

The code seems to work correctly if I use...

Thank you for your thoughts and effort on this.

Your answer seems oh so close and it certainly is fast! However, it doesn't quite work the way I need it...

Hi. I'm presently using this solution to my problem and it does indeed work. The only drawback is that it takes a long time.

This code bit is the...

That's it! Thanks.

If I understand the problem properly I think that this would work.

SELECT

IDENTITY(INT,) AS pKey

,*

INTO ##T1

FROM [YOUR TABLE]

This will give you a temporary table with pKeys

Then you...

Is it wrong to use code you don't understant? 😉

It'll take me a little while to figure out exactly what this does but it does indeed work.

Thanks so much!