By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| COL | st | t_stamp |
|---|---|---|
| 50A_100 | Entered | 2024-03-28 08:59:13.727 |
| 50A_100 | Picked | 2024-03-28 09:30:20.237 |
| 50A_100 | Delivered | 2024-03-28 09:56:42.570 |
| 60B_125 | Entered | 2024-03-28 08:59:22.290 |
| 60B_125 | Picked | 2024-03-28 09:31:32.543 |
| 60B_125 | Delivered | 2024-03-28 09:56:50.683 |
| 50A_171 | Entered | 2024-03-28 14:31:28.480 |
| 70B_211 | Entered | 2024-03-28 14:31:33.613 |
| t_stamp | 50A_100 | 60B_125 | 50A_171 | 70B_211 |
|---|---|---|---|---|
| 2024-03-28 08:59:13.727 | Entered | null | null | null |
| 2024-03-28 08:59:22.290 | null | Entered | null | null |
| 2024-03-28 09:30:20.237 | Picked | null | null | null |
| 2024-03-28 09:31:32.543 | null | Picked | null | null |
| 2024-03-28 09:56:42.570 | Delivered | null | null | null |
| 2024-03-28 09:56:50.683 | null | Delivered | null | null |
| 2024-03-28 14:31:28.480 | null | null | Entered | null |
| 2024-03-28 14:31:33.613 | null | null | null | Entered |
| t_stamp | 50A_100 | 60B_125 | 50A_171 | 70B_211 |
|---|---|---|---|---|
| 2024-03-28 08:59:13.727 | Entered | null | null | null |
| 2024-03-28 08:59:22.290 | null | Entered | null | null |
| 2024-03-28 09:30:20.237 | Picked | null | null | null |
| 2024-03-28 09:31:32.543 | null | Picked | null | null |
| 2024-03-28 09:56:42.570 | Delivered | null | null | null |
| 2024-03-28 09:56:50.683 | null | Delivered | null | null |
| 2024-03-28 14:31:28.480 | null | null | Entered | null |
| 2024-03-28 14:31:33.613 | null | null | null | Entered |
[50A_100],[60B_125],[50A_171],[70B_211]
select *
from
(
select CONCAT(PartNum,'_',ID) COL
,st,
t_stamp
from (select ID,PartNum,
EnteredOn as Entered,
PickedTime as Picked,
DeliveredTime as Delivered
from mytable) m
unpivot
(
t_stamp
for st in ([Entered]
,[Picked]
,[Delivered]
)
) unpiv
) src
pivot
(
max(st)
for COL in ([50A_100],[60B_125],[50A_171],[70B_211] )
) piv;