Posted by Jimbo on 12/21/06 17:26

Im having problems with an after insert trigger...

Im trying to join the INSERTED table with other tables to retrieve
data....Some of these tables it must link to get data inserted into
them at the same time my original table does...my question is why when
the trigger runs, my sql statement gets no data...however afterwards if
I run the statement and use the primary key that was just inserted, the
statement brings up data?..

I hope I was clear enough..

-Jim

[Back to original message]