求一函数，要求输入一个时间段如2004-5-8至2007-5-7 把这个时间段的所有年月列出来！请高人帮帮忙啊！！

[litao3029]

求一函数，要求输入一个时间段如2004-5-8至2007-5-7 把这个时间段的所有年月列出来！
如：
2005-5
2005-6
2005-7
...

2007-5


请高人帮帮忙啊！！

[huailairen]

create function list_days(@begin datetime,@end datetime)
returns @t table(a datetime)
as
begin
declare @tmp datetime
set @tmp=@begin
while @tmp<=@end
begin
insert into @t values(@tmp)

set @tmp=dateadd(dd,1,@tmp)
end

return
end

select * from dbo.list_days

[huailairen]

create function list_days(@begin datetime,@end datetime)
returns @t table(a datetime)
as
begin
declare @tmp datetime
set @tmp=@begin
while @tmp<=@end
begin
insert into @t values(@tmp)

set @tmp=dateadd(dd,1,@tmp)
end

return
end

select * from dbo.list_days('2002/1/1','2002/1/7')

a
------------------------------------------------------
2002-01-01 00:00:00.000
2002-01-02 00:00:00.000
2002-01-03 00:00:00.000
2002-01-04 00:00:00.000
2002-01-05 00:00:00.000
2002-01-06 00:00:00.000
2002-01-07 00:00:00.000

（所影响的行数为 7 行）

[wangdehao]

alter function returntime
(
@begindt datetime,
@enddt datetime
)returns @re table(col varchar(100))
as
begin
declare @dt datetime
set @dt = @begindt
while @dt<@enddt
begin
insert @re select convert(varchar(7),@dt,120)
set @dt = dateadd(month,1,@dt)
end

return
end


select * from dbo.returntime('2005-07-08','2006-08-21')
-----
/**
结果:
col
------------
2005-07
2005-08
2005-09
2005-10
2005-11
2005-12
2006-01
2006-02
2006-03
2006-04
2006-05
2006-06
2006-07
2006-08

***/

[wangdehao]

alter function returntime
(
@begindt datetime,
@enddt datetime
)returns @re table(col varchar(100))
as
begin
declare @dt datetime
set @dt = @begindt
while @dt<=@enddt
begin
insert @re select convert(varchar(7),@dt,120)
set @dt = dateadd(month,1,@dt)
end

return
end

[litao3029]

wangdehao(找找找） 的正确！多谢了！