By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
| dt | workorder | workcenter | target | itemcode | size | qty | qtyperh | end_dt |
|---|---|---|---|---|---|---|---|---|
| 22/07/2019 07:00:00 | 41051 | 1 | 10 | 600111 | 14L-16.1 | 45 | 10 | 22/07/2019 08:00:00 |
| 22/07/2019 08:00:00 | 41051 | 1 | 10 | 600111 | 14L-16.1 | 35 | 10 | 22/07/2019 09:00:00 |
| 22/07/2019 09:00:00 | 41051 | 1 | 10 | 600111 | 14L-16.1 | 25 | 10 | 22/07/2019 10:00:00 |
| 22/07/2019 10:00:00 | 41051 | 1 | 10 | 600111 | 14L-16.1 | 15 | 10 | 22/07/2019 11:00:00 |
| 22/07/2019 11:00:00 | 41051 | 1 | 10 | 600111 | 14L-16.1 | 5 | 10 | 22/07/2019 12:00:00 |
| 22/07/2019 12:00:00 | 41051 | 1 | 5 | 600111 | 14L-16.1 | -5 | 10 | 22/07/2019 12:30:00 |
| 22/07/2019 07:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 50 | 5 | 22/07/2019 08:00:00 |
| 22/07/2019 08:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 45 | 5 | 22/07/2019 09:00:00 |
| 22/07/2019 09:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 40 | 5 | 22/07/2019 10:00:00 |
| 22/07/2019 10:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 35 | 5 | 22/07/2019 11:00:00 |
| 22/07/2019 11:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 30 | 5 | 22/07/2019 12:00:00 |
| 22/07/2019 12:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 25 | 5 | 22/07/2019 13:00:00 |
| 22/07/2019 13:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 20 | 5 | 22/07/2019 14:00:00 |
| 22/07/2019 14:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 15 | 5 | 22/07/2019 15:00:00 |
| 22/07/2019 15:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 10 | 5 | 22/07/2019 16:00:00 |
| 22/07/2019 16:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 5 | 5 | 22/07/2019 17:00:00 |
| 22/07/2019 17:00:00 | 41052 | 1 | 5 | 600112 | 14L-16.2 | 0 | 5 | 22/07/2019 18:00:00 |