Get current week data in SQL Server

Select current entries from table.
T-SQL

DECLARE @TableX TABLE
([Date] DATETIME)
INSERT INTO @TableX
SELECT '2011-11-28' UNION ALL
SELECT '2011-11-25' UNION ALL
SELECT '2011-11-27' UNION ALL
SELECT '2011-11-29' UNION ALL
SELECT '2011-11-30' UNION ALL
SELECT '2011-11-11' UNION ALL
SELECT '2011-11-21' UNION ALL
SELECT '2011-12-01'
SELECT * FROM @TableX
WHERE
DATE BETWEEN 
DATEADD(DD, 1 - DATEPART(DW, GETDATE()),GETDATE())
AND
DATEADD(DD, 1 - DATEPART(DW, GETDATE()),GETDATE())+7

That’s It.
Enjoy Learning.