sql server select查询报错“ 从数据类型 nvarchar 转换为 numeric 时出错”

Question

SELECT MAX(a.todaymaxvol) aa,a.towernumber FROM (
**SELECT CONVERT(decimal(20,2), LTrim(RTrim(volume))) todaymaxvol , towernumber FROM catch_gas (nolock) WHERE CONVERT(varchar(100), time,20)>='2019-02-10
08:30:59'
AND CONVERT(varchar(100), time, 20) <='2019-02-11 08:30:59' AND towernumber <>'140807101810（二期）' **
) a GROUP BY towernumber

单独执行**中间的select 是可以出结果的
，只要一排序或者分组就会报错

Answer 1

加个判断过滤一下试试 ISNUMERIC(a.todaymaxvol)>0