>I've got something wrong as I get "The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified."
>
>The extra field doesn't bother me (yet anyway) so for now...I think...I like the field :)
>

The ORDER BY should be at the very end of your code, e.g.

select * from (our actual select statement) derived ORDER BY 1,6

But keep the field and be happy :)