>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
I'm not using buffering on the view, it is pointing to a temporary table on SQL Server - when finished, I fire a remote stored procedure to do the update internally on SQL (including dropping and rebuilding indexes).
I only asked for an SPT way because I feel like I'm 'stepping back' using the view - I would rather do it with SPT if this was possible. Just exploring all the avenues!