How to show date (mm/dd/yyyy) between two dates
_______________________________________________
declare @dateh table(ind int identity(1,1),date1 smalldatetime,date2 smalldatetime)
insert into @dateh select '1/1/2011','1/15/2011'
;with T as
(
select date1,date2 from @dateh as d
union all
select dateadd(dd,1,date1),date2 From T
where dateadd(dd,1,date1)<= date2
)
Select date1 from T
No comments:
Post a Comment