> I
> don't understand why these preceeding tables act like they're
> receiving data but end up empty when the first table copies correctly.
> I'm using a procedure where I pass a table name and copy all records
> and all fields to the target table. I'm thinking that, if my
> procedure was flawed, the first table processed wouldn't be getting
> any data.
>
> Any ideas?

Perhaps your transactions are started before the original table data
is committed. If this is the case, your transaction wont see the data
inserted by the other transaction.

Adam