Id use rownumber.

its so flexible and powerful for when you have duplicate records

try the following.

CREATE TABLE ##X

(COL1 NVARCHAR(10),COL2 NVARCHAR(10))

INSERT INTO ##X(COL1,COL2)

SELECT

'951' AS COL1,'454215' AS COL2...