ID of a specific sort primary key added to an existing record table

1. Declare employee_cursor cursor
2. Select updatetime, ID
3. From tblsimaccounthistory
4. Order by updatetime, ID
6. Open employee_cursor
9. Declare @ updatetime datetime
10. Declare @ ID decimal
11. Declare @ hid decimal
12. Select @ hid = 1
13. Fetch next from employee_cursor
14. Into @ updatetime, @ ID
15. While @ fetch_status = 0
16. Begin
18. Update tblsimaccounthistory set hid = @ hid where id = @ ID and updatetime = @ updatetime
20. Select @ hid = @ hid + 1
21. Fetch next from employee_cursor
22. Into @ updatetime, @ ID
24. End
26. Close employee_cursor
27. Deallocate employee_cursor