This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I use MS SQL Server. I don't know what I'm doing wrong in the following query.
I receive this error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','.
select (table.isNegative, matchType.code, keyword.id, status.code, keyword.lastUpdate, syncStatus.code)
from table kwd, matchType, keyword k, status, syncStatus
I'm going to guess that "table" is a reserved word in your database. (Do you really have a table named "table"?)
Joined: Nov 01, 2011
Found the problem! Needed to remove the open and close () from the beginning and end of SELECT statement which got rid of the first error. Then I got "cannot be bound" error which I resolved when I replaced the actual table names with the names which was defined in from statement: kwd for table and k for keyword.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com