Hey all I need help to fix this problem.
I run a query like this:

INSERT INTO [RDI_Test.Deleted].dbo.[Nominee]([Given Name],[Surname],
[OwnerID],[TitleID]) SELECT ([Given Name],[Surname],[OwnerID],
[TitleID]) FROM #Temp_Deleted

and got this error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','.

Can anyone point out the problem? Thank you.

There is no need to use parenthesis for the columns in the select list:

INSERT INTO [RDI_Test.Deleted].dbo.[Nominee](
[Given Name],
[Surname],
[OwnerID],
[TitleID])
SELECT [Given Name],
[Surname],
[OwnerID],
[TitleID]
FROM #Temp_Deleted;


--
Plamen Ratchev
http://www.SQLStudio.com

Thanks for the solution. It solved my headache.