I'll look into the xp_cmdshell issue.

But anyway, I am perfectly happy with your suggested solution ! So, no hurry.

Cheers.

Garry

Brilliant Steve.

It is not exactly the way I would have liked it, but I now know it is the closest I am going to get.

Thanks a bunch for...

Steve, Adam,

Thanks for the fast reply ! It's highly appreciated.

And I believe Adam is right; I can't seem to find any details on the use of the Inserted and Deleted tables....

I am supprised that the query does not return all of the Null records.

The attached JPEG shows the tables and their sample content I used while testing, together with the...

It think this is your  "viewable" solution ... Again, Copy/Paste into SQL Query Analyzer,

test it, wrap it up in a "Create View" statement.

Because of...

Cam,

Consider the following construction : (You may want to copy/paste text between the dashed lines to your SQL Query Analyzer)

Although this probably returns the results you want, it will not fit...