that's what actually i am doing now - using a temp table 2 step process, but wondering if there is a one-step process, thx

quote:

---

I would have a 2 step approach, Insert all the records into a temp table. Alter the table to include the identity...