By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
51 rows affected
f_dateid | f_tmf_abc | f_werks | f_matnr | f_wa_menge_fert | dateid | Total_Menge_FERT_ABC | WERKS | MATNR | WA_Menge_FERT | runtotal | WA_Menge_FERT_count# |
---|---|---|---|---|---|---|---|---|---|---|---|
20240429 | 61 | 1010 | 59025 | 3 | 20240429 | 61 | 1010 | 59025 | 3 | 3 | 1 |
20240429 | 61 | 1010 | 59025 | 3 | 20240513 | 58 | 1010 | 59025 | 3 | 6 | 2 |
20240429 | 61 | 1010 | 59025 | 3 | 20240527 | 43 | 1010 | 59025 | 2 | 8 | 3 |
20240429 | 61 | 1010 | 59025 | 3 | 20240603 | 38 | 1010 | 59025 | 1 | 9 | 4 |
20240429 | 61 | 1010 | 59025 | 3 | 20240610 | 33 | 1010 | 59025 | 1 | 10 | 5 |
20240429 | 61 | 1010 | 59025 | 3 | 20240617 | 31 | 1010 | 59025 | 0 | 10 | 6 |
20240429 | 61 | 1010 | 59025 | 3 | 20240624 | 31 | 1010 | 59025 | 0 | 10 | 7 |
WERKS | DateID | MATNR | Total_Menge_FERT_ABC | WA_Menge_FERT | Ergebnis |
---|---|---|---|---|---|
1010 | 20230626 | 59025 | 23 | 11 | 3 |
1010 | 20230703 | 59025 | 133 | 10 | null |
1010 | 20230710 | 59025 | 124 | 9 | null |
1010 | 20230717 | 59025 | 44 | 19 | 18 |
1010 | 20230724 | 59025 | 0 | 6 | 1 |
1010 | 20230731 | 59025 | 0 | 6 | 1 |
1010 | 20230814 | 59025 | 0 | 4 | 1 |
1010 | 20230821 | 59025 | 0 | 0 | 1 |
1010 | 20230828 | 59025 | 0 | 0 | 1 |
1010 | 20230904 | 59025 | 0 | 0 | 1 |
1010 | 20230911 | 59025 | 0 | 0 | 1 |
1010 | 20230918 | 59025 | 0 | 0 | 1 |
1010 | 20230925 | 59025 | 47 | 1 | 17 |
1010 | 20230925 | 59025 | 35 | 2 | 17 |
1010 | 20231002 | 59025 | 31 | 0 | 25 |
1010 | 20231009 | 59025 | 1 | 0 | 4 |
1010 | 20231016 | 59025 | 1 | 0 | 3 |
1010 | 20231030 | 59025 | 0 | 0 | 1 |
1010 | 20231106 | 59025 | 1 | 1 | 1 |
1010 | 20231113 | 59025 | 0 | 0 | 1 |
1010 | 20231120 | 59025 | 62 | 20 | 23 |
1010 | 20231127 | 59025 | 0 | 0 | 1 |
1010 | 20231204 | 59025 | 0 | 0 | 1 |
1010 | 20231211 | 59025 | 0 | 0 | 1 |
1010 | 20231225 | 59025 | 48 | 4 | null |
1010 | 20240101 | 59025 | 46 | 1 | null |
1010 | 20240108 | 59025 | 32 | 1 | 16 |
1010 | 20240122 | 59025 | 32 | 0 | 15 |
1010 | 20240129 | 59025 | 31 | 0 | 14 |
1010 | 20240205 | 59025 | 31 | 0 | 13 |
1010 | 20240212 | 59025 | 31 | 0 | 12 |
1010 | 20240219 | 59025 | 0 | 0 | 1 |
1010 | 20240226 | 59025 | 0 | 1 | 1 |
1010 | 20240304 | 59025 | 0 | 0 | 1 |
1010 | 20240311 | 59025 | 0 | 0 | 1 |
1010 | 20240318 | 59025 | 0 | 0 | 1 |
1010 | 20240325 | 59025 | 0 | 0 | 1 |
1010 | 20240401 | 59025 | 0 | 0 | 1 |
1010 | 20240408 | 59025 | 82 | 17 | null |
1010 | 20240415 | 59025 | 16 | 12 | 4 |
1010 | 20240422 | 59025 | 0 | 0 | 1 |
1010 | 20240429 | 59025 | 61 | 3 | null |
1010 | 20240513 | 59025 | 58 | 3 | null |
1010 | 20240527 | 59025 | 43 | 2 | null |
1010 | 20240603 | 59025 | 38 | 1 | null |
1010 | 20240610 | 59025 | 33 | 1 | null |
1010 | 20240617 | 59025 | 31 | 0 | null |
1010 | 20240624 | 59025 | 31 | 0 | null |
1044 | 20230626 | 59025 | 31 | 0 | null |
1044 | 20230703 | 59025 | 31 | 0 | null |
1044 | 20230710 | 59025 | 31 | 0 | null |