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) |
8 rows affected
| name |
|---|
| barangay1 |
| barangay2 |
| barangay3 |
| barangay4 |
| barangay5 |
| barangay6 |
| barangay7 |
| barangay8 |
| month | name |
|---|---|
| 1 | January |
| 2 | February |
| 3 | March |
| 4 | April |
| 5 | May |
| 6 | June |
| 7 | July |
| 8 | August |
| 9 | September |
| 10 | October |
| 11 | November |
| 12 | December |
| name | month | monthname |
|---|---|---|
| barangay1 | 1 | January |
| barangay1 | 2 | February |
| barangay1 | 3 | March |
| barangay1 | 4 | April |
| barangay1 | 5 | May |
| barangay1 | 6 | June |
| barangay1 | 7 | July |
| barangay1 | 8 | August |
| barangay1 | 9 | September |
| barangay1 | 10 | October |
| barangay1 | 11 | November |
| barangay1 | 12 | December |
| barangay2 | 1 | January |
| barangay2 | 2 | February |
| barangay2 | 3 | March |
| barangay2 | 4 | April |
| barangay2 | 5 | May |
| barangay2 | 6 | June |
| barangay2 | 7 | July |
| barangay2 | 8 | August |
| barangay2 | 9 | September |
| barangay2 | 10 | October |
| barangay2 | 11 | November |
| barangay2 | 12 | December |
| barangay3 | 1 | January |
| barangay3 | 2 | February |
| barangay3 | 3 | March |
| barangay3 | 4 | April |
| barangay3 | 5 | May |
| barangay3 | 6 | June |
| barangay3 | 7 | July |
| barangay3 | 8 | August |
| barangay3 | 9 | September |
| barangay3 | 10 | October |
| barangay3 | 11 | November |
| barangay3 | 12 | December |
| barangay4 | 1 | January |
| barangay4 | 2 | February |
| barangay4 | 3 | March |
| barangay4 | 4 | April |
| barangay4 | 5 | May |
| barangay4 | 6 | June |
| barangay4 | 7 | July |
| barangay4 | 8 | August |
| barangay4 | 9 | September |
| barangay4 | 10 | October |
| barangay4 | 11 | November |
| barangay4 | 12 | December |
| barangay5 | 1 | January |
| barangay5 | 2 | February |
| barangay5 | 3 | March |
| barangay5 | 4 | April |
| barangay5 | 5 | May |
| barangay5 | 6 | June |
| barangay5 | 7 | July |
| barangay5 | 8 | August |
| barangay5 | 9 | September |
| barangay5 | 10 | October |
| barangay5 | 11 | November |
| barangay5 | 12 | December |
| barangay6 | 1 | January |
| barangay6 | 2 | February |
| barangay6 | 3 | March |
| barangay6 | 4 | April |
| barangay6 | 5 | May |
| barangay6 | 6 | June |
| barangay6 | 7 | July |
| barangay6 | 8 | August |
| barangay6 | 9 | September |
| barangay6 | 10 | October |
| barangay6 | 11 | November |
| barangay6 | 12 | December |
| barangay7 | 1 | January |
| barangay7 | 2 | February |
| barangay7 | 3 | March |
| barangay7 | 4 | April |
| barangay7 | 5 | May |
| barangay7 | 6 | June |
| barangay7 | 7 | July |
| barangay7 | 8 | August |
| barangay7 | 9 | September |
| barangay7 | 10 | October |
| barangay7 | 11 | November |
| barangay7 | 12 | December |
| barangay8 | 1 | January |
| barangay8 | 2 | February |
| barangay8 | 3 | March |
| barangay8 | 4 | April |
| barangay8 | 5 | May |
| barangay8 | 6 | June |
| barangay8 | 7 | July |
| barangay8 | 8 | August |
| barangay8 | 9 | September |
| barangay8 | 10 | October |
| barangay8 | 11 | November |
| barangay8 | 12 | December |
7 rows affected
| bname | monthname | amount |
|---|---|---|
| barangay1 | January | 5345.00 |
| barangay1 | February | 123.00 |
| barangay1 | March | 0.00 |
| barangay1 | April | 0.00 |
| barangay1 | May | 8000.00 |
| barangay1 | June | 0.00 |
| barangay1 | July | 0.00 |
| barangay1 | August | 0.00 |
| barangay1 | September | 0.00 |
| barangay1 | October | 0.00 |
| barangay1 | November | 0.00 |
| barangay1 | December | 0.00 |
| barangay2 | January | 34.00 |
| barangay2 | February | 111.00 |
| barangay2 | March | 0.00 |
| barangay2 | April | 0.00 |
| barangay2 | May | 0.00 |
| barangay2 | June | 2000.00 |
| barangay2 | July | 0.00 |
| barangay2 | August | 0.00 |
| barangay2 | September | 0.00 |
| barangay2 | October | 134.00 |
| barangay2 | November | 0.00 |
| barangay2 | December | 0.00 |