Good tip. You are the best at searching non links.

I didn't guest, I've read a lot of forums.

you can check this link: http://sqlblog.com/blogs/paul_white/archive/2010/08/27/sorting-row-goals-and-the-top-100-problem.aspx

Actually the problem on that forum is different, is based on the big difference on speed...

Hi guys,

thanks for the help, finally this morning after a good sleep I've seen the problem.

You were right, the sorting was not deterministic enough, but yesterday I was so...

The sorting is on a DateTime field, the values are the same only in the group, the rest of the records are different. So it's not possible to have more...

If I put max([DateCreated]) in the select the result is the same, actually the DateCreated is the same for all records in the same group. The problem is that the...