Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Split data from 1 table to 2 tables

Author  Topic  LamboG Starting Member 4 Posts Posted - 2009-07-29 : 07:24:28 Hi, hoping for some help please. We have data from different clients in 1 table. For a particular client, the loading of their pages are getting very slow so I need to remove their data prior to 01/01/09 and place in a new table. The Start Date filter on the front end will be defaulted to 01/01/09 but this data does need to be available incase they set the date filter prior ro 01/01/09. What's the best way to do all of this process? Bear in mind, I only need to get the data prior to 01/01/09 if the date filter is set and to ignore it otherwise.