通过将星期三设置为一周的第一天来逐周选择数据

I would like to create a stored procedure that I can select data week by week. How can this be done? Here is my situation, the employees fill up the timesheet every day and payment is made weekly every Wednesday morning. So Wednesday is the first day of the week. I want to display the data in a gridview. In my gridview, each page in the gridview should represent each week the employees work. For example, if there are 7 records and today is Wednesday 02 Oct, 2013 and each record for each day in the last 7 days, soI would like to create a stored procedure that