I have a table with data structured like this:
I want to create a query that takes that data and does this:
Is that even possible? How do I get started?
Code:
Emp# ST OT
--------------------
30174 1421 540
30180 1882 518
30200 2400 0
30223 2271 66
Code:
Emp# ST OT
--------------------
30174 1421 0
30174 0 540
30180 1882 0
30180 0 518
30200 2400 0
30200 0 0
30223 2271 0
30223 0 66