By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
15 rows affected
CustomerNumber | Company | Year | WeekNumber | LeadDays_1 | OrderDate_1 | DeliveryDate_1 | LeadDays_2 | OrderDate_2 | DeliveryDate_2 | LeadDays_3 | OrderDate_3 | DeliveryDate_3 | LeadDays_4 | OrderDate_4 | DeliveryDate_4 | LeadDays_5 | OrderDate_5 | DeliveryDate_6 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5002 | Comp_A | 2022 | 15 | 1 | 2022-04-03 | 2022-04-04 | 1 | 2022-04-04 | 2022-04-05 | 1 | 2022-04-05 | 2022-04-06 | 1 | 2022-04-06 | 2022-04-07 | 1 | 2022-04-07 | 2022-04-08 |
19401 | Comp_B | 2022 | 15 | 1 | 2022-04-04 | 2022-04-05 | 1 | 2022-04-05 | 2022-04-06 | 1 | 2022-04-06 | 2022-04-07 | 1 | 2022-04-07 | 2022-04-08 | 1 | 2022-04-08 | 2022-04-09 |
310365 | Comp_A | 2022 | 15 | 1 | 2022-04-05 | 2022-04-06 | 1 | 2022-04-07 | 2022-04-08 | null | null | null | null | null | null | null | null | null |
310428 | Comp_A | 2022 | 15 | 1 | 2022-04-06 | 2022-04-07 | null | null | null | null | null | null | null | null | null | null | null | null |
Warning: Null value is eliminated by an aggregate or other SET operation.