
However I'm finding that if I want to ORDER BY by a particular field in a table, I have to SELECT that field, otherwise I get an error : ColNum 65535 exceeds columns.
Is anyone else seeing this, or am I doing something silly..? Same query works perfectly in Management Studio.