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
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com