>>I think what you can do is wrap your SPT with a scan...
>
>That was my original program - inserting from the current table colums. This worked fine but bloated my transaction log because of the 'tweeking' I had to do to get the speed up!

So, you are saying you tried this method, and appending to a remote view and calling tableupdate() is faster?

I assume you use table buffering on the view?

The view is the way I would do it, but you asked for an SPT way. Seems to me the more C++ code that is doing the job (append from, tableupdate), the faster it will be.

BOb