467,915 Members | 1,268 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Incorrect syntax near ','

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.
Sep 9 '08 #1
  • viewed: 1893
Share:
2 Replies
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
Sep 9 '08 #2
Thanks for the solution. It solved my headache.
Sep 9 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jeff Magouirk | last post: by
4 posts views Thread by Carl | last post: by
1 post views Thread by Sandesh | last post: by
1 post views Thread by iporter | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.