Add AutoNumber To SELECT Statement

If you ever have a need to return Row Number along with recordset:

SELECT
(SELECT
COUNT(A.ColumnName) + 1
FROM
dbo.TableName AS A
WHERE
A.ColumnName < B.ColumnName) AS RowNumber
, B.ColumnName
FROM
dbo.TableName AS B
ORDER BY
B.ColumnName