Invalid Sql for Paging when Subquery contains Order By clause using MsSql2005Dialect

When using the MSSql2005Dialect a paginq query that also has a subquery with an order by statement will product invalid sql.

The problem is that the code to transform the sql query into a paging query looks for the index of the last order by clause in the sql statement. If the main query does not have an order by statement it will use the index of the order by statement for the subquery. This then causes the code to produce invalid sql.