Lynn Pettis (9/11/2012)

---

GSquared (9/11/2012)

---

Lynn Pettis (9/11/2012)

---

Here is a bit of code that returns what you are looking for:

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

with SevenRows(n) as (select row_number() over (order by (select null)) - 1 from (values (1),(1),(1),(1),(1),(1),(1))dt(n))

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

It's the SQL 2005 forum, Lynn. He might not have access to TVFs.

SQL Server 2005 has table valued functions, I'm lost.