If the target table has an identity column defined, then don't include it in your insert statement and it will be automatically populated at the time of insert.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg