SQL: Msg 116, I got this error creating a field´s value

Hi, In sub query select statement Should return always single column not multiple, but in your query it return multiples. Please check your sub query.

Ramon Quintana7y ago

Hi,

NOTHING YET, I used it in the select statement but nothing, same error.

Anything else?

What i want to do is this:

https://www.c-sharpcorner.com/forums/how-to-do-a-sum-inside-a-case-when-clause

Thanks,

Amit Gupta7y ago

Your select statement might return multiple values, use either 'Top 1 from ' or use group by clause, if you are fetching aggregate in your select statement to get the error free result.