By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | Period Month | 01 | 02 | Employee Code |
|---|---|---|---|---|
| 1 | 202401 | K | L | 005678 |
| 2 | 202401 | S1 | M | 005678 |
| 3 | 202401 | K | S1 | 005678 |
| 4 | 202401 | M | S1 | 005678 |
| Employee Code | Period Month | Date | Value |
|---|---|---|---|
| 005678 | 202401 | null | K |
| 005678 | 202401 | null | L |
| 005678 | 202401 | null | S1 |
| 005678 | 202401 | null | M |
| 005678 | 202401 | null | K |
| 005678 | 202401 | null | S1 |
| 005678 | 202401 | null | M |
| 005678 | 202401 | null | S1 |