I have a super query ID: 41792646 that gives me the sum of the ascii chararcters in a string word. The string only ever contains one word. if i do:
select word, dbo.func_ASCIIEncodeString(TblCurrentWords.word) as AsciiSum
I get output (the words are not duplicated in the tblcurrentwords) yet when I do:
SET AsciiEncode = (
I get error:
Msg 512, Level 16, State 1, Line 5
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
assistance would be appreciated.