By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| ID | Str | FreeSpace | DriveLetter | Total | Server | Date |
|---|---|---|---|---|---|---|
| 3 | 33^D:\ ^ 40^Test2 ^2018-10-1 08:10:01.000 | 33 | D:\ | 40 | Test2 | 2018-10-1 08:10:01.000 |
| 1 | 57^H:\ ^ 200^Test ^2018-09-19 08:20:01.000 | 57 | H:\ | 200 | Test | 2018-09-19 08:20:01.000 |
| 2 | 8^T:\ ^ 88^Test1 ^2018-09-1 08:00:01.000 | 8 | T:\ | 88 | Test1 | 2018-09-1 08:00:01.000 |
Warning: Null value is eliminated by an aggregate or other SET operation.