Home > IT Answers > Development > Subquery returned more than 1 value.
Bbonsall
0 pts.
 Subquery returned more than 1 value.
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.

Software/Hardware used:
ASKED: November 6, 2006  1:51 PM
UPDATED: November 7, 2006  9:54 AM
RELATED QUESTIONS
Answer Wiki:
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...
Last Wiki Answer Submitted:  November 7, 2006  9:54 am  by  TNCaver   0 pts.
All Answer Wiki Contributors:  TNCaver   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _