>I'd like to select all rows from a table containing the column daynumber(int) (Sunday = 1) for a range of dates
>
>Any ideas?

Can you clarify your table structure? The simplest way to solve your problem would be to have Calendar table in your database.