Results 1 to 4 of 4

Thread: Copy Data Issue

  1. #1
    Join Date
    Mar 2004
    Posts
    33

    Unanswered: Copy Data Issue

    I need to create a new field and copy over an existing field from the same table. Since this table is about 3 million rows. It will take about 1 hour 30 minutes to complete.

    Any good way around?


    Thanks!

    -J8

    -----------------------------------------
    UPDATE Customer SET ColB = ColA WHERE ColA IS NOT NULL

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    What (if any) point is there to this exercise?

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check this thread out.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Mar 2004
    Posts
    33
    The New column ColB will become a key column for sorting and also accept new kind of data while orig. ColA column continually receive data as it was. the historical data need to be copy over for sorting ...

Posting Permissions

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