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
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place