Adding data randomly into a column of a table

• malavika.ramanathan

  SSCrazy

  Points: 2790

  More actions

  November 23, 2010 at 5:05 am

  #231585

  Hi All,

  I have a table with two columns : ID and Name

  Now two new columns are to be added.

  so i added two more columns (say Age and Gender).

  Now, i need to update the table to fill in these two columns.

  there are 1 million records in the table.

  Can i do something to randomly generate values for Age column (below 100) and for Gender(either 1 or 2) using Dynamic Sql or Bulk Insert?

  Is there anything like that?

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  November 23, 2010 at 6:30 am

  #1254403

  For ages up to 100, try

  SELECT RandomAge = 1 + abs(checksum(newid()))%100

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

• Pravasis

  Default port

  Points: 1455

  More actions

  November 23, 2010 at 8:15 am

  #1254487

  I think redgate has some tool to prepare the test data. you can chek the same.

  Regards,
  Pravasis