Tuesday, May 14, 2013

How to get date between two Dates in a month


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