Get How Many Sunday in a given Month using sqlserver

Select DateDiff(ww,'3/1/2014','3/31/2014')as NumOfSundays

or

declare @startdate datetime

declare @enddate datetime

declare @TotalSundays int

declare @TotalOtherDays int

set @startdate = '2/1/2009'set @EndDate = '2/28/2009'

set @TotalSundays = (select datediff(day,@startdate,@enddate) /7 + case

when datepart(Weekday,@StartDate) = 1

then 1

when datepart(Weekday,@StartDate) > datepart(Weekday,@EndDate)

then 1

else 0 end)

set @TotalOtherDays = datediff(day,@StartDate,@EndDate) - @TotalSundays

select @TotalSundays

select @TotalOtherDays