SELECT Col1, Col2, ROW_NUMBER() over (ORDER BY col1) AS Number FROM tableName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)