I tried your way and got this everytime I create the index

Unable to create index 'PK_Weather'. 

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key...