Thanks

I tried to learn from your script. I applied it to my project and it seems to be working. Could you please explain me couple of questions, which I don't...

Thank you. I need a bit time to understand all parts of it.

I found it: I changed the Temp table for the Test table in your code.

It seems to be working just fine. I will give it a deeper look.

Thank you.

It seems to be worse now:

Thanks for your reply. I think I am missing something: the rawData does not have Name column. Is perhaps cte.Name missing in the select statement?

Also [rawData].[Length] is meant to be...

Added a script

I created a CTE table for AA=1 and used a join with a table containing only the rows with AA =2. That is working.

Thanks for help.

Thanks for answer.

I am not concerning about values per se. Sure, the numbers are random, so values will be different each time I run the query.

My concern is, that I...

I see. I thought that the rank is calculated based on column(s) in a partition and not in the 'order by' clause.

Thank you for help.

It is expected to delete workstations from the first table, which have the same Guid but different Id in the second table.

The script is an extract from the bigger script....