主题：批量执行SQL语句，返回的表记录为空

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() 没有返回数据

在查询分析器里面是可以查出数据来的

请赐教，谢谢！

此主题相关图片如下：hj.jpg

不是的，我在查询分析器里面没有错误的

这个是我在查询分析器执行的结果

 

此主题相关图片如下：qq截图20130619091757.jpg

这个是代码，数据库就给不了，太大了

Dim cmd As new SQLCommand
Dim ck As String
Dim dt As DataTable
cmd.C
ck="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,"
ck=ck+"Std_Manhrs AS std_manhrs FROM prddrd)a "
ck=ck+" WHERE ISNULL(Leader,'')<>'' "
ck=ck+" SELECT leader,AVG(kpi) AS kpi FROM #temp group by leader "
cmd.CommandText = ck
MessageBox.Show(ck)
dt = cmd.ExecuteReader()
Tables("窗口1_Table1").DataSource=dt

查询出来没有结果，但是查询分析器有返回结果的

应该是临时表的问题,貌似临时表查不出来