【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“实例165计算员工全年工作日.sql”一文,供大家参考学习
select datename(dw,'2008-01-01') as '2008-01-01星期几',
datename(dw,'2008-12-31') as '2008-12-31星期几',
datediff(wk,'2008-01-01','2008-12-31') as 全年星期数,
(datediff(day,'2008-01-01','2008-12-31') -
(datediff(ww,'2008-01-01','2008-12-31'))*2) -
(select 全年请假天数 from tb_AllYearPay where 员工编号='mr001' )
as 员工编号001全年
工作日