Thank you for the answer.

What you suggest is what I'm doing today, I would like to forbid this kind of method.

Do you have another solution to so the same without...

Just amazing ! 😉

Working exactly how I expect

You really deserve to be a MVP !!

I'm still questioning myself about the keywords "OVER" and "PARTITION" its really interesting to do this...

Hello again,

Thank you again.

In fact "idx" is not an attribute but a column from the table

so I replaced

by

and its working...

The data from the table are like this:

ID: int, PK auto inc

Data: XML

data sample in attachment

Hello back 😉

So about my last reply, I made a mistake when writing back your query and its working but not exactly how I want.

All the xml content are included...

Re.

Its not working 🙁

Please look at the attachment to see the outputs.

Hi Mark

Thank you for this crazy answer 🙂

I never used something so complex, in fact never used "WITH" or "DENSE_RANK"

Let me a few hours to see if its solving...

Hello again,

I provided in attachmenet a more clear and complet file with my current real situation.

If you need more informations to understand my problem, please feel free to ask me.

Thank...

Hi Mark,

Thanks for this first answer.

I didn't knew the "root()" function, this is very interesting 🙂

Your solution is working but it's just answering the half of my problem.

First point: Is...

it seams like the code were trunk

please found here as attachment the full question with code 😉