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 >>