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.