cengland0 (1/10/2011)
Koen (da-zero) (1/10/2011)
What kind of trigger? The question asks if it is possible with a trigger. So it is up to you to find out if there is a trigger that can do this. That's the whole point of the question.I understand that you cannot update data in the TEMPORARY INSERTED table. I thought that question asked about Updating any row in the table was that that you inserted the record in -- not the temporary one. I was confused on the definition of "INSERTED table" thinking that could mean the table you just inserted the record in. Understand the issue now?
I surely understand the issue. I had to read the question a few times in order to get it right.
The thing that finally made the trick for me was that INSERTED was in upper case, so I thought it had to be the special temp table.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP