DECLARE @StartDate DATETIME
SET @StartDate='01/01/'+DATENAME(Year,GETDATE())


;WITH CTE AS
(
	SELECT @StartDate as dt, 1 as Id

	UNION ALL

	SELECT DATEADD(dd,1,dt),CTE.Id + 1
	FROM CTE
	WHERE Id <= 365
)
SELECT ROW_NUMBER()OVER(ORDER BY dt) AS ID,
dt AS SATSUNDate,DATENAME(dw,dt) AS [Day]
FROM CTE A
WHERE (DATEPART(dw,dt)=1 OR DATEPART(dw,dt)=7) --this will give you all SAT & SUN List
OPTION (MAXRECURSION 0);