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.