How to Split and Combine Data in Tables in MS SQL 2000

Hi all,

This is my first post to this Forum. We are working on a project where scanned documents are stored into MS SQL database. There is only one table in the database. As it is with images, the size of the database is growing as 2 to 3 GB per day. To handle the database safely we thinking of splitting the database according to one key field say Book_no.
How to split the table with the query like "select * from doc_master where book_no=1", and split the table for each book numbers and later combine them to form a single original table. Please give me some suggestion/guidence. Its very urgent.

----
Regards,
Rajeev Vandakar

Hi Rajeev!
Although, there are several ways to do it. You can use Select into statement to solve the problem. But, for each book you have to write a SQL statement. Something like this --

(I suppose the Library as name of base table)

Select * into book1 from Library where book_id=1
Select * into book2 from Library where book_id=2
...
...

This example would create two tables named book1 and book2. In which book1 contains only rows from book_id=1.

Reply soon ..

- Som Dutt