I suppose that's true! I can manually export the contents of the temp table to my 2 other tables because the keydata indentity of the 1st table will be...

I tried it with a regular table and It gives me:

The target table 'BatchInsertTemp7' of the OUTPUT INTO clause cannot have any enabled triggers.

I remember reading in the Insert Output...

Ok I'm getting this error:

Cannot create trigger on a temporary object.

Ok, I'm looking up temporary tables and triggers. Let's see if I can apply these concepts. 🙂

Damn! I'm having trouble ammending this statement to insert into an additional DestinationTable3

How might I OUTPUT INSERTED INTO 2 tables?

That totally works! Thanks muy mucho!

Here's the code for anyone else with the same task:

_____________________________________________

use mydatabase

INSERT Into DestinationTable1

(fname, lname)

OUTPUT INSERTED.SourceTableId, '26'

INTO DestinationTable2

(SourceTableId, ClientID)

SELECT

fname, lname

FROM SourceTable

WHERE SourceTableId = '97854'...

Ok, thanks Chris.

I looked it up. Lemmie see if I can figure out how to make it work with the code I've got. Thanks.