Hi Eirikur,

Thanks for your help. Much appreciated.

Oh and you can ignore the Tag_ID - its the primary key from another table. I shouldn't have included it in the results. Sorry.

Also the original query called it Rank. Its really policy subgroup, I guess you say.

I did think to start with I was getting the same issue. But I now see that its swapped the two policy sub groups around. Which I don't think will be an issue. The CSN isn't as far as I can see important other than to distinguish the sub groups.

I assume this is due to the combination of the query order by and the Row_number order by @@version - which I didn't know about.

I shall now test against other policies - I was only given the one to test against. And I shall let you know the outcome. But its looks promising based on this this test case.

Many thanks,

Rodney