Subquery returned more than 1 value.

0 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.
ASKED: November 6, 2006  1:51 PM
UPDATED: November 7, 2006  9:54 AM

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following