ID Name Request Date
296459 Waiting 2016-06-04 22:53:46.000
296459 ED-22 2016-06-04 23:01:30.650
296459 CCS-CC28-A 2016-06-05 01:16:00.000
296459 4N-N450-A 2016-06-14 06:33:41.530
I would like to create a new row called End Date which would contain the Request Date from the next row.
ID Name Request Date End Date
296459 Waiting 2016-06-04 22:53:46.000 2016-06-04 23:01:30.650
296459 ED-22 2016-06-04 23:01:30.650 2016-06-05 01:16:00.000
296459 CCS-CC28-A 2016-06-05 01:16:00.000 2016-06-14 06:33:41.530
296459 4N-N450-A 2016-06-14 06:33:41.530 GETDATE()
Aucun commentaire:
Enregistrer un commentaire