Symptom
- Procedure is written in the Transact-SQL syntax
- Variable gets set based on a query that returns zero to n rows
- The format of the statement is: SELECT <variable> = <column> FROM <table> WHERE <condition>
- The execution of the statements results sometimes in error -185 "SELECT returns more than one row"
=