Thanks for the tips. I ended up going a different route instead which will eliminate my database from growing. What I did is generate an excel report around midnight and when the users are running reports they will be pointing to the reports pre-generated.