select dateadd(day,datediff(day,0,getdate()),-number) as BackDate from ( select top 7 row_number() over (order by name) as number from sysobjects ) as t
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)