DECLARE @SQL NVARCHAR(4000),
        @Day INT
set @Day=1

 select case when grouping(AreaName)=1 then '合计'  else cast(AreaName as nvarchar(100)) end AreaName,
    case when grouping(BuildName)=1 and grouping(AreaName)=0 then '小计' else cast(BuildName as nvarchar(100)) end BuildName,
Sum([COUNTER]) as FailureCount,SUM([FAX]) AS FAX from
(
    SELECT   COUNT(f.FailureID) AS [COUNTER],
             COUNT(k.FailureID) AS [FAX],
           max(w.[LocationName]) AS BuildName, 
           (SELECT LocationName FROM dbo.ReportLocation WHERE LocationID = w.ParentLocationID) AS AreaName        
    FROM   
            dbo.ReportLocation w
            LEFT JOIN
            (
                    select FailureID,ReportDateTime,LocationID,BuildingID from View_ReportFailure
                WHERE  DATEPART(Day, ReportDateTime) = 1
            )f 
                ON  f.[BuildingID] = w.[LocationID]
            LEFT JOIN
            (
                select FailureID,ReportDateTime,LocationID,BuildingID from View_ReportFailure
                WHERE  DATEPART(Day, ReportDateTime) = 1 and [status]=4
            )k
            on  w.[LocationID]=k.[BuildingID] 
    WHERE w.IsEnabled = 1 AND w.ParentLocationID IS NOT NULL   
    GROUP BY w.[LocationID],w.ParentLocationID
    )z
 group by AreaName,BuildName with rollup