sqlvogel (11/25/2013)

---

adams.squared (11/25/2013)

---

The question is:

Is there a way to get a single value for the four columns, aside from concatenation and not using identity?

Sorry but if you care about what the numbers are then you clearly can't/shouldn't be using IDENTITY to generate them. If you want to rebuild the table while retaining the same numbers then for most practical purposes it doesn't make sense to use IDENTITY. IDENTITY is best avoided in data warehouse / data integration situations - at least as a way of generating keys for a target table. A SEQUENCE is somewhat better because you can generate the values independently of the table.

SEQUENCE or not, this is a common situation and it really isn't a difficult problem to solve but I'm not sure why you think you have to use an IDENTITY column to do it.