Hi, i have table in db as below deptId deptName 9 10 11 13 groupName A G1 B C G2 ------ -------- --- --- --- --- ---------- ---- --- --- ---- --- 8 Doctors 2 2 0 0 Permanent 0 1 0 0 1 8 Doctors 2 2 0 0 Apprentice 0 0 0 0 1 have any ways to get the table as below Permanent Apprentice ------------- ----------- deptId deptName 9 10 11 13 groupName A G1 B C G2 A G1 B C G2 ------ -------- --- --- --- --- ---------- ---- --- --- ---- --- -- -- -- -- -- 8 Doctors 2 2 0 0 Permanent 0 1 0 0 1 0 0 0 0 1 where A,G1,B,C,G2 are the shift in permanent group in a department. Thanks..
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)