insert into select from in a table with identity column

Posted by nitroxn on Stack Overflow See other posts from Stack Overflow or by nitroxn
Published on 2010-03-16T13:39:08Z Indexed on 2010/03/16 13:46 UTC
Read the original article Hit count: 471

Filed under:
|
|
|
|

Hi, I am using a insert into select from statement to insert the result set of a query into a table containing an identity column. I am consistently getting an error Cannot insert duplicate key row in object 'dbo.TABLE1' with unique index 'IX_TABLE1'.

Please help

© Stack Overflow or respective owner

Related posts about sql

Related posts about insert