Convert Column to row (pivot)

Question

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 i want it to be like this :

*just ignore the Status field

so the data reimbursement_type to become a column head and it SUM each amount.

i already tried using pivot but didnt get what i expected.

thx

http://stackoverflow.com/questions/13372276/simple-way-to-transpose-columns-and-rows-in-sql/13377114#13377114 — TheGameiswar, Oct 20 '16 at 07:52

score 2 · Answer 1 · answered Oct 20 '16 at 08:02

2

Prepared a sample according to your requirement. As you have mentioned to ignore Status, I am not considering it into the query.

select * from 
(
select employee_id,reimbursement_type,amount from md_reimbursement
)src
pivot
(
sum(amount) for reimbursement_type in ([Biaya Dinas],[Other],[Transport],[Uang Makan])
)pvt

answered Oct 20 '16 at 08:02

maulik kansara

1,087
6
21

thx maulik, it works. – Borom1r Oct 20 '16 at 08:09

Convert Column to row (pivot)

1 Answers1