DECLARE @Month int
DECLARE @Year int
Declare @TempStartDate Datetime, @TempEndDate Datetime
set @Month = 5
set @Year = 2014
select @TempStartDate= DATEADD(month,@Month-1,DATEADD(year,@Year-1900,0))
select @TempEndDate= DATEADD(day,-1,DATEADD(month,@Month,DATEADD(year,@Year-1900,0)))
SELECT [Date] = DATEADD(Day,Number,@TempStartDate)
FROM master..spt_values
WHERE Type='P'
AND DATEADD(day,Number,@TempStartDate) <= @TempEndDate
If you got exactly what you want then click accept solution.