Jeff Moden (2/15/2013)
OTF (2/15/2013)
You can also take a look at using OUTPUT.I've found that to be a wee bit more difficult than you would think unless you have an alternate key to reliably express the new value across the other tables.
With that thought in mind, do you have a coded example of how to do this?
This used to be true in SQL 2005, but it's no longer true as of SQL 2008. I'll work on writing up an article in the next few days.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA