Yes, I have some common fields, and these are used in the join clause, so the result dataset is as small as possible.

Is there some solution to this or is...

Hi Matt

I have criterias on the joins, but i did'nt write them in the post, sorry for that. Even though I have criterias its still a very large dataset!

Why do...

John, what I meant was that the following flow takes place:

Call1: delete data

Call1: start insert

--Now call one has inserted 5000 rows.

Call2: delete data

Call2: start insert

Call1: completed insertion

Call2: completed insertion

The last...