Another Insert question. My SQL PC is busy at the moment so I can't test this...
Can you *insert into tablename select * from othertable* when you have an identity column in the table? Or would it be better to have the identity column in the *from* table and protect it in the receiving table??