I quoted directly out of Using Microsoft SQL Server 6.5, Special Edition so :-)...didn't want to take any chances of a "whoops"


>>OK Nigel ---
>>
>>As I understand it, let's say Table A has columns A,B,C,D and A is an identity. Table B had E,F,G,H. Since A is an identity, it should auto-increment when records are added and, therefore, shouldn't be mirrored in the select portion (this only works if B=F,C=G,D=H in structure). Then...
>>
>>insert into table_a (b,c,d) values (select f,g,h from table_b)
>>
>>This should work.
>>
>>
>
>Thanks, I'll try that (when my SQL PC has finished its deleting) although I didn't think you could do it like that - the documentation says INSERT INTO tablename SELECT ... which is why I posted this thread.