select dateadd(dd,num,@begintime) FROM (SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS num FROM sysobjects) KK where dateadd(dd,num,@begintime) <=@endtime
select dateadd(dd,num,@begintime) FROM (SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS num FROM sysobjects) KK where dateadd(dd,num,@begintime) <=@endtime