select a.leader,a.item_no,a.avgproduct,a.std_manhrs,round(a.avgproduct/a.std_manhrs,2) as kpi into #temp from(SELECT leader,item_no,case isnull(Total_hrs,0) when 0 then 0 ELSE Finish_Qty/Total_hrs END AS avgproduct,
Std_Manhrs AS std_manhrs FROM prddrd)a
WHERE ISNULL(Leader,'')<>''
SELECT leader,AVG(kpi) AS kpi FROM #temp group by leader
我用ExecuteReader() 没有返回数据
在查询分析器里面是可以查出数据来的
请赐教,谢谢!