SELECT ROW_NUMBER() OVER(ORDER BY [col_1]) as RowNumber, COUNT([col_1]) OVER () AS RecordCount,* FROM TableName
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)