SELECT * FROM ( SELECT datename(month,date_recieving) As [Month], current_status, ID FROM files ) t PIVOT ( COUNT(ID) FOR current_status IN ([Pending],[Closed]) ) as pvt
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)