I have a table like below in SQL Server. I reach the row number values with using ROW_NUMBER partition function. But this was not the result I wanted to achieve.
| RowNumber | Value |
|---|---|
| 1 | A |
| 2 | A |
| 3 | A |
| 1 | B |
| 2 | B |
| 1 | C |
| 1 | D |
I want to get this table
| RowNumber | Value |
|---|---|
| 1 | A |
| 1 | A |
| 1 | A |
| 2 | B |
| 2 | B |
| 3 | C |
| 4 | D |
How can I do it, do you have a function suggestion?
