Incorrect syntax near ','

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • ghozan

    #1

    Incorrect syntax near ','

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

    INSERT INTO [RDI_Test.Delete d].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.
Working...