icampbell (1/15/2008)
The table is created, then the data inserted from the view.I have a seperate procedure that fires every minute that works for inserts.
However how do i do a triger for updates.
So the view is based on a different table than you want to update?
Then look at Andras's post. He details an instead of trigger, which is what you'll need.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability