>Would the inserted table in the trigger have the indentity values in it? I never tried that. If it does, it would be a simple matter to store them to another table.
Interesting question. I've never checked.
It appears that the Inserted table does contain the assigned IDENTITY values. You can see for yourself with the follow script:
USE pubs
CREATE TABLE testtable (c int identity(1,1), name nvarchar(40))
CREATE TRIGGER testtable_insert ON testtable FOR INSERT
AS
SELECT * FROM inserted
INSERT INTO testtable (name)
SELECT au_lname FROM authors
INSERT INTO testtable (name)
SELECT au_lname FROM authors
WHERE au_lname LIKE 'b%'
-Mike