select 员工编号,sum(datediff(d,调休开始日期,调休结束日期)) as 调休天数
from
(
select 员工编号,调休开始日期,
case when end_Date between '2005-01-01' and '2005-12-31' then 调休结束日期
else '2005-12-31' end as 调休结束日期
from T_Employee_MoveRest_Info
where begin_Date between '2005-01-01' and '2005-12-31'
)t
group by 员工编号
from
(
select 员工编号,调休开始日期,
case when end_Date between '2005-01-01' and '2005-12-31' then 调休结束日期
else '2005-12-31' end as 调休结束日期
from T_Employee_MoveRest_Info
where begin_Date between '2005-01-01' and '2005-12-31'
)t
group by 员工编号
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货