34,590
社区成员
发帖
与我相关
我的任务
分享
select 被考核人,cast(datepart(month,考核时间) as varchar(10)) + '月' as 月份,sum(次数*b.分数) as 总分 from 绩效管理_考核列表 a
inner join 绩效管理_考核指标 b on a.指标项=b.指标序号
group by 被考核人,a.考核时间 having 被考核人=1
DECLARE @startdate DATETIME ,
@enddate DATETIME
SET @startdate = '2000-01-01'
SET @enddate = '2014-12-31' --最多只能产生 2005 8
SELECT
DISTINCT
YEAR(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [year] ,
MONTH(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [month]
FROM master..spt_values
WHERE DATEDIFF(day, DATEADD(day, number, @startdate), @enddate) >= 0
AND number >= 0
AND type = 'p'
DECLARE @startdate DATETIME ,
@enddate DATETIME
SET @startdate = '2008-01-01'
SET @enddate = '2009-12-31'
SELECT
DISTINCT
YEAR(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [year] ,
MONTH(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [month]
FROM master..spt_values
WHERE DATEDIFF(day, DATEADD(day, number, @startdate), @enddate) >= 0
AND number >= 0
AND type = 'p'