We executed a dynamic SQL statement (not a complex one) and we have an order by clause at the end of it. This statement does a join of 2 tables. The strange thing is that the order by seem like it doesn't work. The results are not in sequential order.
If we were to do a straight select on just one table (for which we are doing the order by on) everything is ok.