By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Id | Name | LoginTime | LogoutTime |
|---|---|---|---|
| 1 | a | 2022-03-01 09:00:00.000 | 2022-03-01 15:00:00.000 |
| 2 | a | 2022-03-02 02:00:00.000 | null |
| 3 | a | 2022-03-03 10:00:00.000 | 2022-03-18 11:00:00.000 |
| 4 | a | 2022-03-04 07:00:00.000 | null |
| 5 | b | 2022-03-04 07:00:00.000 | 2022-03-18 08:00:00.000 |
| 6 | a | 2022-03-05 20:00:00.000 | null |
| 7 | b | 2022-03-06 08:00:00.000 | null |
| 8 | a | 2022-03-06 10:00:00.000 | 2022-03-18 11:00:00.000 |
| 9 | b | 2022-03-04 16:00:00.000 | null |
| Id | Name | LoginTime | LogoutTime | LogoutTime_New |
|---|---|---|---|---|
| 1 | a | 2022-03-01 09:00:00.000 | 2022-03-01 15:00:00.000 | 2022-03-01 15:00:00.000 |
| 2 | a | 2022-03-02 02:00:00.000 | null | 2022-03-03 09:59:59.000 |
| 3 | a | 2022-03-03 10:00:00.000 | 2022-03-18 11:00:00.000 | 2022-03-18 11:00:00.000 |
| 4 | a | 2022-03-04 07:00:00.000 | null | 2022-03-05 19:59:59.000 |
| 5 | b | 2022-03-04 07:00:00.000 | 2022-03-18 08:00:00.000 | 2022-03-18 08:00:00.000 |
| 6 | a | 2022-03-05 20:00:00.000 | null | 2022-03-06 09:59:59.000 |
| 7 | b | 2022-03-06 08:00:00.000 | null | null |
| 8 | a | 2022-03-06 10:00:00.000 | 2022-03-18 11:00:00.000 | 2022-03-18 11:00:00.000 |
| 9 | b | 2022-03-04 16:00:00.000 | null | 2022-03-06 07:59:59.000 |