There's no direct way to do this. @@IDENTITY and SCOPE_IDENTIY() will only catch the last row inserted. You could probably do something with triggers. The INSERTED table will contain the rows that were added. It would just be a matter of matching them up to the actual table to get the identity values.

-Mike

>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