I have two database applications. One that terminated in the 3rd week of January 2013 and the new one that picked up that same week. The database tables and fields are not the same and they need to be combined for reporting purposes. What are the best practices in order to combine them with SQL Server.
For instance if I have to combine two different fields from two different applications into one field for reporting purposes how do I do that is it even possible and what affect does the datetime stamps affect the outcome. I understand some SQL just have never combined them before. Any help advice documents video how to's appreciated.