Original table:
| ID | Name | -------------- | 1 | Mark | -------------- | 2 | Mich | -------------- | 3 | Isak | --------------
Now I add another column ( of type int ), e.g. Ordinal_Number :
| ID | Name | Ordinal_Number | ------------------------------- | 1 | Mark | | ------------------------------- | 2 | Mich | | ------------------------------- | 3 | Isak | | -------------------------------
Now I need to fill Ordinal_Number with the number of previous records :
| ID | Name | Ordinal_Number | ------------------------------- | 1 | Mark | 0 | ------------------------------- | 2 | Mich | 1 | ------------------------------- | 3 | Isac | 2 | -------------------------------
Ordinal_Number = COUNT(*) FROM MyTable
Ordinal_Number = COUNT(*) FROM MyTable WHERE Ordinal_Number <= current_records_Ordinal_Number_value;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)