Subject Re: Which way is best...
Author Michael Vilhelmsen

Either way could be implemented.

I have tried a stored procedure.
It work. But I lack response from the server while the rutine runs.

I havn't tried the

insert Into table )
Select value, value from table where condition

And here I will NOT select records I insert.

But I could also do it with unidirectional set to TRUE.
This actually completed with no errors.

But which is best ?

There will be other clients connected at this point, so the impact
should be as small as posible to them.