sharonsql2013 (5/4/2015)

---

Thanks. Tweaked it a bit to get different columns

declare @ThisDate datetime;

set @ThisDate = GETDATE();

with ThreeWeek as (select rn from (values (0),(1),(2))dt(rn))

select distinct dateadd(wk, datediff(wk, 0, @ThisDate) + (0), 0) FirstWeek

,dateadd(wk, datediff(wk, 0, @ThisDate) + (1), 0) Secondweek

,dateadd(wk, datediff(wk, 0, @ThisDate) + (2), 0) ThirdWeek

from ThreeWeek;