Finding all sundays and saturdays in a year

Question

I WANT TO FIND ALL THE SUNDAYS AND SATURDAYS IN A YEAR PLUS THEIR DATES ALSO IN SQL

Rajeesh Menoth · Answer

Hi ravi rawat  Your Problem solved ? if helpful please accept the answer .

Rajeesh Menoth · Answer

Hi ravi rawat  Thank you for appreciation : )

Rajeesh Menoth · Answer

Hi declare @startDate date@enddate date set @startDate='01/01/2012' set @enddate='12/31/2012' while @startDate begin if(DATENAME(dw@startDate)='Sunday' or DATENAME(dw@startDate)='Saturday') insert into MyHoliday(Holiday_dateSpecification) values(convert(date@startDate103)DATENAME(dw@startDate)) set @startDate=DATEADD(DD1@startDate) end Ref this : http://stackoverflow.com/questions/9570087/how-to-check-if-datetime-happens-to-be-saturday-or-sunday-in-sql-server-2008 http://forums.asp.net/t/1795730.aspx?Sql+Query+For+Getting+Sundays+And+Saturdays+in+a+given+Year