Look up Partitoned Views in Books Online, it does exactly what you want, (ie selectively reads data from either or both DB's according to the date span required)
1. A good source for information on some of the "undocumented stuff" is Ken Henderson's book "The Guru's Guide to SQL Server Stored Procedures XML and HTML" (It's a good...