using Toad For SQL Server 126.96.36.1992
I have a query that I am running that has a number of subqueries (functions) that return fields however when I run my query I am getting an error that is something like (this is paraphrasing, I dont have the exact text in front of mesubquery returned more than 1 record, can't have this when you use "=", "<"...
how do you troubleshoot this? also it lists the “line” number of the error, is that the record where the error occurs?
by matter of elimination (meaning commenting out the function that I think would cause this) I figured out which function is causing the issue.
I plan on taking the PrimaryKeyID of the “line” listed in the error and running the subquery/function to see what’s going on.
Does this sound correct?