Luis Cazares (9/12/2012)

---

In 2005 there are TVF (Table Valued Functions)

There are not Table Value Constructors.

Is that what you meant?

It can be fixed by

declare @TestDate date = '2012-09-12';

with SevenRows(n) as (

select row_number() over (order by (select null)) - 1

from (SELECT TOP 7 NULL FROM sys.columns)dt(n)

)

select dateadd(dd, n,dateadd(wk,datediff(wk,0,dateadd(dd,-1,@TestDate)),0))

from SevenRows;