TRXCODE in ( select JY_DM from TJFX_JYDM where STOP='0' group by JY_DM)
and '2003-05-01'<= WORKDATE and WORKDATE <='2003-05-13'
group by case when ISNUMERIC(BRNO)=0 then cast(brno as int) else brno end order by wdcount desc
and '2003-05-01'<= WORKDATE and WORKDATE <='2003-05-13'
group by case when ISNUMERIC(BRNO)=0 then cast(brno as int) else brno end order by wdcount desc
select count(BRNO), wdcount,BRNO from TJFX_JYLOG200305 where TRXCODE in ( select JY_DM from TJFX_JYDM where STOP='0' group by JY_DM) and '2003-05-01'<= WORKDATE and WORKDATE <='2003-05-13' group by case when ISNUMERIC(BRNO)=1 then cast(cast(brno as int) as varchar(100)) else brno end order by wdcount desc
From (Select BRNO = case when BRNO like '0%'
then cast(cast(brno as int) as varchar(100))
else brno end)
from TJFX_JYLOG200305
where TRXCODE in
(select JY_DM from TJFX_JYDM where STOP='0' group by JY_DM)
and '2003-05-01'<= WORKDATE and WORKDATE <='2003-05-13') T
group by BRNO
order by wdcount desc
未找到预期 from 关键字。