I have a view that returns data in this fashion:
ID FEE Amount
001 710 10.00
001 720 20.00
But I need to display the data as:
ID R_fee C_fee
001 amount amount
I know I should use a case statement for this. Can anyone shed some light on how this should be done?