Hi,
Finally Done
try this
SELECT Employeeid,processmonth,D13 as LoanAdvance, D14 as MandatoryPF
from (SELECT Employeeid, processmonth, deductioncode,Amount
FROM temp1) p
Pivot(avg (Amount) for deductioncode in(D13,D14))as aaaa
I learned lot from this Question.
Thanks.
*Note- Dont use [] ok
Good Luck