I'd insert into a temp table that does use an identity. You can set the seed to be the "pop" value from your separate table and then update that at the end. Be sure you lock this value until then (use a transaction). Insert into your table from the temp table..

Steve Jones

sjones@sqlservercentral.com

http://qa.sqlservercentral.com/columnists/sjones

http://www.dkranch.net