SELECT Dep_Name,Date,sum(Area_total_RT) as AreaTotalRT,sum(Actual_hours) as ActualHours FROM dbo.[S_Basic]

where 1=1

${if(len(GAP) == 0,"","and a.Gap_code in ('" + GAP+ "')")}

${if(len(year) == 0,"","and year(a.Date) in ('" + year+ "')")}

${if(len(month) == 0,"","and month(a.Date) in ('" + month+ "')")}

${if(len(Dep_Name) == 0,"","and a.Dep_Name = ('" + Dep_Name+ "')")}

group by Dep_Name, Date

分为小组数据跟部门数据。以此类推。

数据结构是什么样的。不同部门的小组名是否有重复？