finding dates in sql

Hello use this query- 

@FirstDateOfYear DATETIME,

@LastDateOfYear DATETIME

-- You can change @year to any year you desire

SELECT @year = 2015

SELECT @FirstDateOfYear = DATEADD(yyyy, @Year - 1900, 0)

SELECT @LastDateOfYear = DATEADD(yyyy, @Year - 1900 + 1, 0)

-- Creating Query to Prepare Year Data

;WITH cte AS (

SELECT 1 AS DayID,

@FirstDateOfYear AS FromDate,

DATENAME(dw, @FirstDateOfYear) AS Dayname

UNION ALL

SELECT cte.DayID + 1 AS DayID,

DATEADD(d, 1 ,cte.FromDate),

DATENAME(dw, DATEADD(d, 1 ,cte.FromDate)) AS Dayname

FROM cte

WHERE DATEADD(d,1,cte.FromDate) < @LastDateOfYear

)

SELECT FromDate AS Date, Dayname

FROM CTE

OPTION (MaxRecursion 370)