Hi Mike,

quote:

---

I'm using the identity function to insert an identity field (as it happens) into a temporary table. I'm seeding the value based on the max from another table.

...

Now although this essentially works in that it provides a unique value, the starting value (7990448) bears no relationship to @Seed1 (1). If I remove the parameter @Seed1 and enter a random starting integer then it works fine.

---

Frank