I need to write a trigger that will update a different table
with the values that were just inserted into the table.
In short, i have a table that is being populated currently,
everything is well, now the customer would like a smaller
index type table based on the values that are being passed
into what will now be referenced as the detail table....
To eliminate a lot of business layer code changes, i would simply
like to place a trigger that updates the index table when an
insert occurs on the detail table.... but i am not sure on how
to get the values of the row that was just inserted, and insert
them into a different table...