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.

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.