..sql
SELECT DATEADD(Day,
1 - ( DATEPART(Weekday, GETDATE()) + @@DATEFIRST - 2 ) % 7 - 1,
GETDATE()) AS BeginDate ,
DATEADD(Day,
7 - ( DATEPART(Weekday, GETDATE()) + @@DATEFIRST - 2 ) % 7 - 1,
GETDATE()) AS EndDate