General information
Forum:
Microsoft SQL Server
Title:
Store mutiple identity values from insert
Hello,
I'm building a stored procedure which inserts multiple records in a table from a select statement like this:
Insert into TargetTable
(Field1, Field2, Field3)
Select Fld1, Fld2, Fld3 From SourceTable
This works fine, but the targettable has an identity field and I want to store the identity values of the added records in another table. I know I kan do this with Fetch Into, but for performance reasons I would like to build one statement to insert values in the targettable and store the resulting identity values in the other table.
Is this possible?
TIA,
Martin
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only