I need to have a series of stored procedures written against my CRM database that will offload all sales and purchase data into a seperate database. This seperate database will contain two simple files - Header table and Detail table. Each night these two tables will be removed and recreated from the tables in CRM.
Three Crystal Reports will be need to run reports off of this simplified db.
The general db schema and report layouts are attached.