SQL Dumbass

Fighting dumbasses, one query at a time…

Migration Issue

Had this nugget of an error come up yesterday during a production migration:

Server: Msg 512, Level 16, State 1, Procedure usp_name, Line 217

Subquery returned more than 1 value. This is not permitted when the
subquery follows =, !=, <, <= , >, >= or when the subquery is used
as an expression.

Seriously.

So, I am supposed to believe that this developer actually performed even the most basic of unit testing on their code? OK, let’s assume that their data in development was such that this code could actually work. What about test and/or QA? Oh, you want to keep blaming the data, saying that the differences in data between environments allows for stuff like this to happen?

Fine.

But you’re still a dumbass.