>>Hi again, All
>>
>>I've got an SP that has the following
>>
>>
>>@TotEAP numeric(6,4)
>>@EAP numeric(7,5)
>>
>>**ListenEAP is already in my table from earlier update
>>
>>Select @TotEAP = (@EAP + ListenEAP)/2 from TestResult where SCN = @SCN &&This works as expected
>>
>>Update TestResult set ECLScore = (Select ECLScore from ScoreTable where @TotEAP between AdjLow and AdjHigh)
>>
>>
>>AdjLow and AdjHigh are numeric(6,4).
>>
>>Here's the problem:
>>
>>The update doesn't happen with @TotEAP defined as a 6,4 (or even a 6,3) but it DOES work if @TotEAP is defined as a 6,2
>>
>>Nothing I'm reading in the help file is giving me any indication as to why it's not? Ideas?
>>
>>Thanks
>
>It depends how AdjLow and AdjHigh defined.
The UPDATE looks a bit strange - do you want to update all rows in the table with the same constant value?
E.g. what does select ECLScore from ScoreTable where @TotEAP between AdjLow and AdjHigh
return?
If it's not broken, fix it until it is.
My Blog