>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.
If it's not broken, fix it until it is.
My Blog