CTE to query the business days of the current week.

gistfile1.sql

SET DATEFIRST 1;
WITH [week]([date]) AS
(
  SELECT
  	DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0)
	UNION ALL
	SELECT
		[date]+1 FROM [week]
	WHERE
		DATEPART(dw, [date]+1) <= 5
)
SELECT * FROM [week];