Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.

Question

0.00/5 (No votes)

See more:

what does this error means.

i have created one stored procdere with empid as input parameter.

it has some sub queries.

Posted 17-Apr-12 20:03pm

syedkhaleel

Add a Solution

Comments

sravani.v 18-Apr-12 2:13am

can you share your stored procedure?

Prasad_Kulkarni 18-Apr-12 2:17am

Please post your sql-query

4 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)

member60 · Answer 1 · 2012-04-17T20:09:00

It seems that the subquery returns more than one records. In this case, the result is a set, not a single value, while which is not allowed in your scenario. To avoid this issue, you may have a try to join the result of this subquery, or use TOP 1 to return only one value.

for more refer:
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/31/771.aspx[^]

P.Salini · Answer 2 · 2012-04-17T20:13:00

Really simple, your sql has a sub query, something like this

SQL

Select * from orders where customer_id = 
  (select customer_id from customer where name ='bob')

Now the query above will only run providing the sub query only returns one record, eg. there is only one Bob.

If there is more then one Bob there will be more then on customer_id return so the ='s operator won't work (you would have to use in or something).

Paste your query so that we can tell you in which other ways you can write it.

Arav Pradeep Gupta · Answer 3 · 2012-04-17T21:16:00

Solution 3

SQL

Use {IN} with where clause of out Query like

select * from Order where cust_id in(subquery here).

TRY..................

Posted 17-Apr-12 21:16pm

Arav Pradeep Gupta

Comments

ChintanHiremath 7-Jan-15 7:55am

Can someone help me with the below query, me too getting the same error

SELECT Distinct T1.QID, T1.Title, T1.Vendorid, T1.Severity, T1.Published, Total
FROM Missing_Patch_Table T1,
(
SELECT QID, COUNT (IP) as Total
FROM Missing_Patch_Table
Group by QID
) as T2
where T1.QID = T2.QID
Order by Total desc, Severity, QID;

This works fine when executed in the SQL Server, but when I use this query in VB or C# I get an error

Tanveer A · Answer 4 · 2012-04-17T21:42:00

Solution 4

use subquery with in or not in keyword instead of = sign

Posted 17-Apr-12 21:42pm

Tanveer A

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0