通过SQL来实现日期明细
我有一个表，存着员工和请假时间，数据表格式如下
name holiday_begin_date holiday_end_date
A 2013-01-16 2013-02-16
b 2013-02-05 2013-02-05
c 2013-02-15 2013-02-17
.. ............ ...........（以下数据省略）
假设，现在是2月份
现在想通过SQL来判断，2月的1~28号，所有员工的休假明细
即想通过当月的日期明细来left join 休假明细.
目前休假明细实现不了，请指教。谢谢
[解决办法]
Create function [dbo].[generateTime]
(
@begin_date datetime,
@end_date datetime
)
returns @t table(date datetime)
as
begin
with maco as
(
select @begin_date AS date
union all
select maco.date+1 as date from maco
where date+1 <=@end_date
)
insert into @t
select * from maco option(maxrecursion 0);
return
end
go
select * from dbo.generateTime('2013-2-1','2013-2-28')
