Subquery returned more than 1 value.

pts.
Tags:
SQL
I've got a SP that has the following line of code: SET @totalLateRecords = (SELECT COUNT(*) FROM tableName WHERE tableName.fieldName <= 61)) I get the error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." When I run the query "SELECT COUNT(*) FROM tableName WHERE tablename.fieldName <= 61))", I will never get more than one record returned. Any idea why the SQL2000 box is throwing this error? Thanks in advance.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Does it still fail if you remove the extra closing paren from the end of the query? I can’t believe it doesn’t give you an “Incorrect syntax near ‘)'” error…

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: