Loading old data into new table!

• Bee Kay

  SSC Rookie

  Points: 46

  More actions

  October 6, 2005 at 12:17 pm

  #91747

  I have data in a normalized form:

  KEY1 | STRING1

  KEY1 | STRING2

  KEY1 | STRING3

  KEY1 | STRING4

  KEY1 | STRING5

  I would like to format it as:

  KEY1 | STRING1 | STRING2 | STRING3 | STRING4 | STRING5 |

  Anyone have any ideas do it quickly?

  One table has 50 million rows and another tabls has 84 million rows of data.

  Thanks,

  Kay

  "

  I have 50 Million rows in a table and they have to loaded into one table.

  There is two data columns per row in addition to keys. I have to merge 5 rows into a single row that will result in row with 10 columns.

  Any suggestions/scripts!

  Thanks.

  Kay"

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 6, 2005 at 12:20 pm

  #595609

  We seriously need more info than that : Help us help you