A computed column in SQL server to do this : I need to update an SQL server computed column with an autogenerate serial based on a ```SELECT ```  date time ascend.

Here is the algorithm on my mind.





```
alter table 
select records order by datetime_col desc
update column_of_interest 
from_above_table 
auto_increment value (1..n)
where 
following datetime_col desc and also 
let auto_increment be unique for each location_col
```

For now my column of interest is null.
I need to populate my column of interest based on the above.