Lynn Pettis (3/27/2013)

---

You have fallen into a common trap. Just because ISNUMERIC(adc.value) = 1 is true does not mean that convert(decimal(11,2), adc.value) will work.

Please read the following article: http://www.sqlservercentral.com/articles/IsNumeric/71512/.