表1:
2013-01-01 2013-12-31
表2:
2013-03-01 2013-03-31
2013-05-01 2013-05-31
表3:
2013-01-01 2013-02-28
2013-04-01 2013-04-30
2013-06-01 2013-12-31
提供测试SQL如下:
create table #a(date1 datetime, date2 datetime)
create table #b(sd datetime, ed datetime)
GO
insert into #a values('2013-01-01', '2013-12-31')
insert into #b values('2013-03-01', '2013-03-31')
insert into #b values('2013-05-01', '2013-05-31')