Sql PIVOT Sample

SELECT a.AttendancesID,a.EmployeeNo,MONTH(a.AttendancesDate) As AttMonth
FROM Attendances a
WHERE YEAR(a.AttendancesDate) = '2010'
GROUP BY a.AttendancesID, a.EmployeeNo, MONTH(a.AttendancesDate)
ORDER BY a.AttendancesID,a.EmployeeNo,AttMonth




SELECT *
FROM (
SELECT a.EmployeeNo,
CASE MONTH(a.AttendancesDate)
WHEN 1 THEN 'January'
WHEN 2 THEN 'February'
WHEN 3 THEN 'March'
WHEN 4 THEN 'April'
WHEN 5 THEN 'May'
WHEN 6 THEN 'June'
WHEN 7 THEN 'July'
WHEN 8 THEN 'August'
WHEN 9 THEN 'September'
WHEN 10 THEN 'October'
WHEN 11 THEN 'November'
WHEN 12 THEN 'December'
END AS AttMonth,a.AttendancesID AS AttCount
FROM Attendances a
WHERE YEAR(a.AttendancesDate) = '2010'
GROUP BY a.EmployeeNo, MONTH(a.AttendancesDate), a.AttendancesID
) DataTable

PIVOT(
COUNT(AttCount)
FOR AttMonth
IN ([January], [February], [March], [April], [May], [June], [July],[August], [September], [October],  [November], [December])
)
PivotTable 
ORDER BY EmployeeNo