declare @todate varchar(10)
declare @frdate varchar(10)
declare @cudate varchar(10)
declare @dtdiff int
declare @cnt int
if object_id (‘tempdb..#tempx’) is not null drop table #tempx
create table #tempx (idx int identity (1,1), cudate varchar(10))
set @frdate = ‘2008-12-30′
set @todate = ‘2009-01-02′
set @cnt = 0
set @dtdiff = datediff(day, convert(datetime, @frdate), convert(datetime, @todate))
while @cnt <= @dtdiff
begin
set @cudate = convert(varchar(10), dateadd(day, @cnt, convert(datetime, @frdate)), 120)
insert into #tempx (cudate) values (@cudate)
set @cnt = @cnt + 1
end
select * from #tempx
