Thanks Wayne. I thought of other way too, and it worked out. I can just add the @maxvalue to the identity column of temp table before inserting into base table....