SELECT nCompanyId, nEmpId, sum(Salary) Salary, sum(TDS) TDS,sum(PF) PF FROM Form16_temp PIVOT( MAX([dAmt]) for [sComp] IN ([Salary],[TDS],[PF]) ) as P group by nCompanyId, nEmpId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)