Thanks perry thats exactly what i needed.

cheers,

iain.

It worked very quick and easy to do.

Thanks for the advice guys!!!:D

Thanks guys,

ill give it a go.

Hi Andras,

I modified your code slightly and it worked.

Thanks,

Iain.

Thanks,

I'll give this a try.

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...

The view is based on several tables

The view is not created from the table,

The table is created from the view.

So i created the table then inserted the data from the view.

I have a script which fires...