query - Select Deptname,Value,Deptname value from table1 Result Deptname Value Deptname Value Dept1 2 Dept2 5
Deptname value Dept1 2 Dept2 5
SELECT * FROM (SELECT value, deptname FROM sap_users) as t pivot (sum(value) for deptname in (dept1, dept2, dept3, etc )) as p
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)