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

Question

0.00/5 (No votes)

See more:

SQL

"select SUM(dr_amount)-SUM(cr_amount)" +
"from Gl_Transaction where Accountno like'1%' select SUM(dr_amount)-SUM(cr_amount)" +
"from Gl_Transaction where Accountno like'2%'" +
"select SUM(dr_amount)-SUM(cr_amount)" +
"from Gl_Transaction where Accountno like'3%'" +
"select SUM(dr_amount)-SUM(cr_amount)" +
"from Gl_Transaction where Accountno like'4%'" +
"select SUM(dr_amount)-SUM(cr_amount)" +
"from Gl_Transaction where Accountno like'5%'";

Posted 25-Jun-14 8:18am

Member 10690757

Updated 25-Jun-14 10:13am

Maciej Los

v2

Add a Solution

Comments

[no name] 25-Jun-14 14:31pm

Use the spacebar where you need to so your string makes sense.

CPallini 25-Jun-14 15:29pm

5.

Member 10690757 25-Jun-14 14:35pm

how?

CPallini 25-Jun-14 15:32pm

For instance, if you concatenate "select SUM(dr_amount)-SUM(cr_amount)" with "from ..." then you obtain "select SUM(dr_amount)-SUM(cr_amount)from ..." which is invalid because there is no blank between the closing brace ')' and 'from'.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-06-25T10:22:00

Solution 1

Adding spacebar does not help ;( Sorry, collegues... Even when OP change the code, this doesn't help too, because He/She will get SQL error.

Do you know SQL? I'd suggest to strat with basics: SQL Tutorial[^]

Posted 25-Jun-14 10:22am

Maciej Los

Mike Meinz · Answer 2 · 2014-06-25T11:31:00

Your example looks like a C# statement although it is syntactically incorrect since there is no operator in the statement. In my solution below, I added a declaration for a string named mySQLStatement and an assignment to that statement of the concatenated strings that you included in your question. The result is that mySQLStatement contains a syntactically correct SQL Statement. I know that is true because I created a table and ran the statement against it.

C#

string mySQLStatement = "select SUM(dramount)-SUM(cramount)" +
"from GlTransaction where Accountno like'1%' select SUM(dramount)-SUM(cramount)" +
"from GlTransaction where Accountno like'2%'" +
"select SUM(dramount)-SUM(cramount)" +
"from GlTransaction where Accountno like'3%'" +
"select SUM(dramount)-SUM(cramount)" +
"from GlTransaction where Accountno like'4%'" +
"select SUM(dramount)-SUM(cramount)" +
"from GlTransaction where Accountno like'5%'";

After executing the above statement the contents of mySQLStatement will be

SQL

"select SUM(dramount)-SUM(cramount)from GlTransaction where Accountno like'1%' select SUM(dramount)-SUM(cramount)from GlTransaction where Accountno like'2%'select SUM(dramount)-SUM(cramount)from GlTransaction where Accountno like'3%'select SUM(dramount)-SUM(cramount)from GlTransaction where Accountno like'4%'select SUM(dramount)-SUM(cramount)from GlTransaction where Accountno like'5%'"

Your SQL statement will create five result sets. While that will work, it may not be the simplest way to retrieve this data. I recommend that you modify your SQL statement to return just one result set with a separate column for each value rather than five result sets of one column each.

Maybe that's not what you really want to do.... You may want to clarify your question using the Improve Question button above and explain what you are trying to accomplish (using an example of what you want the result to look like).