Eirikur Eiriksson (9/27/2016)
rodjkidd (9/26/2016)
Row_number order by @@version - which I didn't know about.I'm just to lazy to write "(SELECT NULL)" when @@VERSION does the same thing, that is tells the server to ignore any specific order and enumerate entries in the order of appearance. In fact one can use any of the @@ functions for this but I've only asserted that the execution plan remains identical with the @@VERSION.
😎
Funny enough to start with I though oh some clever extra usage of @@version in the Order by...
But by the afternoon I had realised it was instead of (SELECT NULL) 🙂
Thanks for the clarification.
Other than it seems to reverse the order of the subgroupings I think this is working on the bigger data set. I'll pass the query over for further testing. I was only given the one insurance policy that wasn't working. A bit of a habit here I have discovered. So I don't know if there are other policies with issues. If it all goes well I will mark the answer as good. Otherwise I will be back with more questions!
Thanks for your help Eirikur.
Cheers,
Rodney