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;