create FUNCTION [dbo].[Fun_getbetwwenmonth](@sdt datetime,@edt datetime)
RETURNS @re TABLE (date DATETIME)
AS
BEGIN
INSERT INTO @re select
convert(varchar(10),dateadd(dd,-1,convert(varchar(8),dateadd(mm,number,@sdt),120)+'01'),120)
from
master..spt_values
where
type='p' and number>0
and
dateadd(mm,number,@sdt)<=dateadd(mm,2,@edt)
RETURN
END
RETURNS @re TABLE (date DATETIME)
AS
BEGIN
INSERT INTO @re select
convert(varchar(10),dateadd(dd,-1,convert(varchar(8),dateadd(mm,number,@sdt),120)+'01'),120)
from
master..spt_values
where
type='p' and number>0
and
dateadd(mm,number,@sdt)<=dateadd(mm,2,@edt)
RETURN
END
posted @ 2011-08-01 10:37 melody&amp;bobo 阅读(9) 评论(0) 编辑