hey guys, i need to make the data in the column to be column head
this is the current result from my query .. :
select employee_id,reimbursement_type,SUM(amount) as [total amount],reimbursement_status from md_reimbursement
group by employee_id,reimbursement_type,reimbursement_status
and what i want is like this :
employee id | Biaya Dinas | Other | Transport | Uang Makan | Status
50006 | 1320484848 | 500 | 150 | 500 | APPROVED
the data in column reimbursement_type converted into column head and sum its amount.
i knew i have to use pivot, but i still dont get the right query.