Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Moving data from one table to another

    I imported a little over 9 million records into my database without "cleaning" the data.

    I'm looking for suggestions on what would be the most efficient way to get all the fields to the correct types and to insert decimals on the fields that need them.

    My only idea thus far is to make another table with the correct field types and append the data to the new table.

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    That's the best way. Think of your existing table as a "Staging" table. Staging tables hold raw data imported into the database, usually without any cleansing or formatting applied. The data is then transfered to one or more production tables by a stored proc that verifies it and reports any abnormalities.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts