Similar results: "Number sequences"
- Number sequences
- An easy way to create the number sequence is to use the IDENTITY function.
SELECT IDENTITY(int,1,1) as RowNum,
The use of IDENTITY function and DISTINCT create some problem because the IDENTITY function will always create a unique row. One way to...