Is the ID field an IDENTITY field?? If it is you can SET IDENTITY_INSERT ON

Then you can insert your identity from table a into table b.

AJ Ahrens

SQL DBA

Revenue Assurance Management - AT&T