获得时间段之间每月的最后一天

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

转载于:https://www.cnblogs.com/bobofsj11/archive/2011/08/01/2123508.html