it sounds like you're in the wromg news group. But yes.

First switch off the column's identity, leaving it just as a BIGINT

the you
INSERT INTO thistable (tableid) values select distinct (col) from tablesource

then turn on the identity again




"tcb" wrote:

I have a PK column defined with.

Identity Specification = Yes
Is Identity = Yes
Identity Increment = 1
Seed = 1

The table has no data. Is it possible to import from another table
with unique numbers into this column?