>>OUTPUT clause was introduced in SQL Server 2005 and it is very handy. Denis Gobo (who you know) wrote a series of good blogs each devoted to one specific new feature in SQL 2005/2008.
>>
>>Take a look at the summary blog
>>
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-advent-2011-recap>>
>>and this particular feature is described in Day 11.
>
>thanks again. If I used a certified Denis technique it is sure to be popular with the DBA at Dow Jones <g>
You can tell him I said "Hi".
If it's not broken, fix it until it is.
My Blog