Imran Nazir (2/1/2014)
You need to use INSTEAD OF UPDATE trigger as well.
I realize that you and I are responding to an 8 year old post but I wouldn't do this through a view. You're going to have to write a bunch of code in the INSTEAD OF triggers anyway. Import the data into a proper staging table and then write code to both validate and distribute the data.
--Jeff Moden
Change is inevitable... Change for the better is not.