Me with an attendance marking application with C#.net and sqlserver, at first I am trying to allocate shifts to each employee in shifts I want to enter in the table all holidays for the corresponding shift. How can I get the dates of all Sundays of the year 2009