>>What does PK definition have to do with my question? (btw, I am too young to remember 1970 commercials)
>
>It's an add-on comment for the solution.
>
>For Naomi's solution to work (and her trigger code solution is a good solution), you need a primary key definition. Otherwise, you can't tie the rows in the inserted table (in the trigger) back to the original rows.
Of course the table has a primary key; all tables of my SQL server database have primary keys. Thank you for clarifying your point.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
