How to copy records in same table as new entry

• Misary

  Grasshopper

  Points: 16

  More actions

  December 8, 2010 at 2:57 am

  #147888

  Hi,

  I have a table having 20 records, the columns are:

  ID (identity column), companyid,.......

  , and I want to copy these 20 records and insert into this same table with

  only different companyid.

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  December 8, 2010 at 4:51 am

  #1260008

  Something of this sort

  INSERTINTO TableName( List of coloumns ) -- Columns other than the IDENTITY Column

  SELECTList of coloumns -- Columns other than the IDENTITY Column

  FROMTableName

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/