| IF OBJECT_ID('tempdb..#rowCountTB') IS NOT NULL | |
| DROP TABLE #rowCountTB; | |
| WITH DistinctTable | |
| AS ( | |
| SELECT DISTINCT [fieldValue] | |
| FROM [tableName] | |
| ) | |
| ,RowNumber | |
| AS ( | |
| SELECT ROW_NUMBER() OVER ( | |
| ORDER BY [fieldValue] | |
| ) AS RowNum | |
| ,[fieldValue] | |
| FROM DistinctTable | |
| ) | |
| SELECT * | |
| INTO #rowCountTB | |
| FROM RowNumber | |
| ORDER BY [fieldValue] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment