WITH A AS (SELECT Area,COUNT(1) AS StatusFROM sssGROUP BY AreaUNIONSELECT Area,COUNT(1) AS StatusFROM sss1GROUP BY AreaUNIONSELECT Area,COUNT(1) AS StatusFROM sss2GROUP BY Area)SELECT A.AREA,'年' AS Time_dimension,SUM(A.Status) StatusFROM AWHERE YEAR(A.Date)=YEAR(GETDATE())GROUP BY A.AREAUNIONSELECT A.AREA,'月' AS Time_dimension,SUM(A.Status) StatusFROM AWHERE MONTH(A.DATE) =MONTH(GETDATE())GROUP BY A.AREA如何修改 需要给Time_dimension参数
