Inserting multiple rows - capture each identity value

• MyTSQLRepl

  SSC Eights!

  Points: 824

  More actions

  February 15, 2010 at 8:54 am

  #220572

  Hello All,

  I have a SP which copies records from a table to the same table with new ItemID where old ItemID matches from the parameter passed. The code enters records in serveral tables.

  When multiple records are inserted from TableA to TableA for ItemID = 2 where ItemID = 1, (table A has Identity column) I need to capture each identity values in a varible = @@Identity. Currently it just stores the last @@identity.

  How should I get every identity values since I have to enter recods in another table for each identity value.

  Thanks,

• Mark Cowne

  One Orange Chip

  Points: 26952

  More actions

  February 15, 2010 at 9:17 am

  #1118838

  Look at the OUTPUT clause for INSERT statements in BOL

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537