You can do table returning functions in sql server 2000 onwards so doing one to give you a table between two dates sould be easy enough. Plus you could add ones without weekends, do it by week or ...