【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供v_SumCheck.sql参考,解决您在v_SumCheck.sql学习中工作中的难题,参考学习。
USE Mis
GO
CREATE VIEW dbo.v_SumCheck
AS
SELECT LEFT(dbo.Checkin.CheckDate, 7) AS CheckMonth, dbo.Employees.EmpNAME,
SUM(dbo.Checkin.qqDays) AS Sumqq, SUM(dbo.Checkin.ccDays) AS SumCc,
SUM(dbo.Checkin.bjDays) AS SumBj, SUM(dbo.Checkin.sjDays) AS SumSj,
SUM(dbo.Checkin.kgDays) AS SumKg, SUM(dbo.Checkin.fdxjDays) AS SumFdxj,
SUM(dbo.Checkin.nxjDays) AS SumNxj, SUM(dbo.Checkin.dxjDays) AS SumDxj,
SUM(dbo.Checkin.cdMinutes) AS SumCd, SUM(dbo.Checkin.ztMinutes) AS SumZt,
SUM(dbo.Checkin.ot1Days) AS SumOt1, SUM(dbo.Checkin.ot2Days) AS SumOt2,
SUM(dbo.Checkin.ot3Days) AS SumOt3, dbo.Employees.DepId
FROM dbo.Checkin INNER JOIN
dbo.Employees ON dbo.Checkin.EmpId = dbo.Employees.EmpId
GROUP BY LEFT(dbo.Checkin.CheckDate, 7), dbo.Employees.EmpNAME,
dbo.Checkin.EmpId, dbo.Employees.DepId