I'm sorry, I didn't see you needed to start from 3.

INSERT INTO Table2 (Number, Name, Address)

SELECT ROW_NUMBER() OVER(ORDER BY Name, Address) + 2 AS counter,

Name, Address

FROM Table1

Sorry also for not putting my name in the reply.

I have such a few time to dedicate to SSC that sometimes I tend to be too concise.

Regards

Gianluca