By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| (No column name) |
|---|
| Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) Jul 25 2020 11:26:55 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
512 rows affected
| (No column name) | (No column name) |
|---|---|
| 2021-01-01 | 2022-05-27 |
3 rows affected
| TheDate | ItemNumber | QOH |
|---|---|---|
| 2021-12-07 | 372620 | 9 |
| 2021-12-08 | null | null |
| 2021-12-09 | 372620 | 11 |
| 2021-12-10 | null | null |
| 2021-12-11 | 372620 | 24 |
| 2021-12-12 | null | null |
| 2021-12-13 | null | null |
| 2021-12-14 | null | null |
| 2021-12-15 | null | null |
| 2021-12-16 | null | null |
| 2021-12-17 | null | null |
| 2021-12-18 | null | null |
| 2021-12-19 | null | null |
| 2021-12-20 | null | null |
| 2021-12-21 | null | null |
| 2021-12-22 | null | null |
| 2021-12-23 | null | null |
| 2021-12-24 | null | null |
| 2021-12-25 | null | null |
| 2021-12-26 | null | null |
| 2021-12-27 | null | null |
| 2021-12-28 | null | null |
| 2021-12-29 | null | null |
| 2021-12-30 | null | null |
| 2021-12-31 | null | null |
| 2022-01-01 | null | null |
| 2022-01-02 | null | null |
| 2022-01-03 | null | null |
| 2022-01-04 | null | null |
| 2022-01-05 | null | null |
| 2022-01-06 | null | null |
| 2022-01-07 | null | null |
| 2022-01-08 | null | null |
| 2022-01-09 | null | null |
| 2022-01-10 | null | null |
| 2022-01-11 | null | null |
| 2022-01-12 | null | null |
| 2022-01-13 | null | null |
| 2022-01-14 | null | null |
| 2022-01-15 | null | null |
| 2022-01-16 | null | null |
| 2022-01-17 | null | null |
| 2022-01-18 | null | null |
| 2022-01-19 | null | null |
| 2022-01-20 | null | null |
| TheDate | Itemnumber | QOH |
|---|---|---|
| 2021-12-07 | 372620 | 9 |
| 2021-12-08 | 372620 | 9 |
| 2021-12-09 | 372620 | 11 |
| 2021-12-09 | 372620 | 9 |
| 2021-12-10 | 372620 | 11 |
| 2021-12-11 | 372620 | 24 |
| 2021-12-11 | 372620 | 11 |
| 2021-12-12 | 372620 | 24 |
| 2021-12-13 | 372620 | 24 |
| 2021-12-14 | 372620 | 24 |
| 2021-12-15 | 372620 | 24 |
| 2021-12-16 | 372620 | 24 |
| 2021-12-17 | 372620 | 24 |
| 2021-12-18 | 372620 | 24 |
| 2021-12-19 | 372620 | 24 |
| 2021-12-20 | 372620 | 24 |
| 2021-12-21 | 372620 | 24 |
| 2021-12-22 | 372620 | 24 |
| 2021-12-23 | 372620 | 24 |
| 2021-12-24 | 372620 | 24 |
| 2021-12-25 | 372620 | 24 |
| 2021-12-26 | 372620 | 24 |
| 2021-12-27 | 372620 | 24 |
| 2021-12-28 | 372620 | 24 |
| 2021-12-29 | 372620 | 24 |
| 2021-12-30 | 372620 | 24 |
| 2021-12-31 | 372620 | 24 |
| 2022-01-01 | 372620 | 24 |
| 2022-01-02 | 372620 | 24 |
| 2022-01-03 | 372620 | 24 |
| 2022-01-04 | 372620 | 24 |
| 2022-01-05 | 372620 | 24 |
| 2022-01-06 | 372620 | 24 |
| 2022-01-07 | 372620 | 24 |
| 2022-01-08 | 372620 | 24 |
| 2022-01-09 | 372620 | 24 |
| 2022-01-10 | 372620 | 24 |
| 2022-01-11 | 372620 | 24 |
| 2022-01-12 | 372620 | 24 |
| 2022-01-13 | 372620 | 24 |
| 2022-01-14 | 372620 | 24 |
| 2022-01-15 | 372620 | 24 |
| 2022-01-16 | 372620 | 24 |
| 2022-01-17 | 372620 | 24 |
| 2022-01-18 | 372620 | 24 |
| 2022-01-19 | 372620 | 24 |
| 2022-01-20 | 372620 | 24 |