declare @T table ( ID int identity primary key, FromDate ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

declare @T table
(
  ID int identity primary key,
  FromDate date,
  ToDate date
)

insert into @T values
('2011-11-10T00:00:00', '2011-11-12T00:00:00'),
('2011-12-12T00:00:00', '2011-12-14T00:00:00')

select row_number() over(order by D.Dates) as SN,
       D.Dates
from @T as T
  inner join master..spt_values as N
    on N.number between 0 and datediff(day, T.FromDate, T.ToDate)
    cross apply (select dateadd(day, N.number, T.FromDate)) as D(Dates)
where N.type ='P'
fork query

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
Results Messages Graph Execution Plan
Download CSV Download XML
:records rows returned in :time ms:cached