Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146

    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
    Location
    Ohio
    Posts
    12,592
    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
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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