我认为您希望对表进行枢轴旋转，以便月份是列名。下面的代码示例没有经过测试，因为您没有提供示例数据。

SELECT 
    COUNT(EVT_CODE) AS OS, EVT_MRC AS DEPARTMENT, 
    DATENAME(MONTH, EVT_CREATED) AS MONTH, 
    YEAR(EVT_CREATED) AS YEAR
FROM
    R5EVENTS
PIVOT  
(  
    COUNT(EVT_CODE) 
FOR [MONTH] IN
    January, February, March, April, May, June, August, September, October, November, December
) AS p 
GROUP BY 
    EVT_MRC, YEAR(EVT_CREATED), DATENAME(MONTH, EVT_CREATED)
ORDER BY 
    'YEAR' DESC