>Boris
>
>AdjLow and AdjHigh are numeric(6,4) fields in the table
>
>
>Both of you
>
>The full SQL is
>
>Update TestResult set ECLScore = (Select ECLScore from ScoreTable where @TotEAP between AdjLow and AdjHigh) where SCN = @SCN
>
>
As Boris and I suggest, just run the inner SQL separately first.
and also check if you have a row where SCN = @SCN
If it's not broken, fix it until it is.
My Blog