By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2017 (RTM-CU30) (KB5013756) - 14.0.3451.2 (X64) Jun 22 2022 18:20:15 Copyright (C) 2017 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
20 rows affected
EoMDate | ManagerId | Supervisors | Clients | Value | ChangeValue | ChangePerc |
---|---|---|---|---|---|---|
2021-01-31 | 1 | 1 | 1 | 170.00 | null | null |
2021-01-31 | 2 | 1 | 1 | 10.00 | null | null |
2021-02-28 | 1 | 1 | 3 | 240.00 | 70.00 | 41.18 |
2021-02-28 | 2 | 1 | 1 | 15.00 | 5.00 | 50.00 |
2021-03-31 | 1 | 2 | 5 | 376.00 | 136.00 | 56.67 |
2021-03-31 | 2 | 1 | 2 | 130.00 | 115.00 | 766.67 |
EoMDate | ManagerId | Supervisors | Clients | Value | ChangeValue | ChangePerc |
---|---|---|---|---|---|---|
2021-01-31 | 1 | 1 | 1 | 170.00 | null | null |
2021-01-31 | 2 | 1 | 1 | 10.00 | null | null |
2021-02-28 | 1 | 1 | 3 | 240.00 | 70.00 | 41.18 |
2021-02-28 | 2 | 1 | 1 | 15.00 | 5.00 | 50.00 |
2021-03-31 | 1 | 2 | 5 | 376.00 | 136.00 | 56.67 |
2021-03-31 | 2 | 1 | 2 | 130.00 | 115.00 | 766.67 |