34,593
社区成员
发帖
与我相关
我的任务
分享
select sum(次数) as 次数,月份 from
(select cast(datepart(month,考核时间) as nvarchar(2))+'月' as 月份,次数 from 绩效管理_考核列表
where 被考核人=50 and datepart(year,考核时间)=datepart(year,getdate())) as abc group by 月份
select cast(datepart(month,考核时间) as nvarchar(2))+'月' as 月份,次数 into #abc from 绩效管理_考核列表
where 被考核人=50 and datepart(year,考核时间)=datepart(year,getdate())
select sum(次数) as 次数,月份 from #abc b group by 月份