Hi,
Please use follow stored procedure, you can get as per your wise
SELECT Employeename,[ML],[CL],Department
FROM
(SELECT
Employeename,
Leavecode,
Department,
Leavecount
FROM
Employee
GROUP BY Employeename,Leavecode,Department,Leavecount
) DataTable
PIVOT
(
MAX(Leavecount)
FOR Leavecode
IN
(
[ML],[CL]
)
)PivotTable
Regards,
anbukrish