SQL Server view doesn't follow ORDER BY Clause
Posted on 2014-09-02
I have a table with 2 columns in SQL Server 2005:
- a currency number from a host system, which is a 3-digit number stored as text and is the PK of the table
- the 3-chararcter ISO code for the currency
I need to view this table "the other way around" with:
- the ISO code as the first column, sorted in ascending sequence
- the corresponding currency number as the second column
So I defined a corresponding view, for which the SQL looks perfect.
But when I open the view, it is still sorted by currency number (second column, on which I have NO sorting defined) although the SQL says ORDER BY ISO (first column) !!!
Is this a bug or a feature ?