Insert From Select

[anselme]

I dont know why this code is not working (for MS SQL 2000)

DECLARE @Name nVarChar

@Name = SELECT DISTINCT Users.Name FROM Users ORDER BY Users.Name

INSERT INTO Local
(Numb, Name, Level) VALUES (0, @Name , 1)

I want to insert into the table Local all the Distinct Names from Users

the datatype of name :
[Name] [nvarchar] (100) NOT NULL UNIQUE NONCLUSTERED

if the name allready exists in the table Localisation I must jump over the error

how can i do it ?


thank you