This is because your aliases. To fix it, use

Order by x

>

>CREATE TABLE #saleshist (sales INT)
>
>INSERT INTO #saleshist VALUES (10)
>INSERT INTO #saleshist VALUES (1)
>
>-- Next order column 1
>SELECT #saleshist.sales as x,sales%10 as sales FROM #saleshist ORDER BY #saleshist.sales
>
>-- BUG: Next order column 2, expected 1
>SELECT sales as x ,sales%10 as sales FROM #saleshist ORDER BY #saleshist.sales
>
>DROP TABLE #saleshist
>

>
>I have lost the SQL 2000 bug feedback page URL, someone can help me.