Getting ID after INSERT statement.

[sjuarez1979]

I am creating a stored procedure that Inserts data into one table and using the new ID of the previously inserted record, Inserts data into another table. How is this acheived most efficiently? The ID of the first inserted set of data is server generated using autonumber.
Thanks for the help!
-sjuarez1979

 

[chiph]

After each insert you do a Select @@IDENTITY, which returns you the number that was assigned.

Chip H.

 

[tlbroadbent]

You can get the last number inserted using @@Identity.

Declare @id Int

Insert Table...

--Load @id with the last inserted identity value.
Select @id=@@identity Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[sjuarez1979]

Thanks! It worked wonderfully!
sjuarez1979