Steve, thanks for the prompty reply.  Your solution works.  I am hoping that I can do this in one pass.  The reason is the real data contents 36 sets of...

Thank you for everyone's input.  Just added a PK to tables (no update or add etc... tables are read only), work just fine. 

Tables on the same database bears no relationship to each other.  Theses tables are read-only.

Thanks!  I'll give that a try.

Any way to copy table along with indexes?  Thanks!

I am running on SQL Server 2000.  Thy are both residing on the same server.  Record or row length is 2510 bytes.  Thanks! 

Thank you for the response, I finally got it to work.  Thanks!