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