专家坐堂-请狐爸高手解答foxtable 的质疑，关于对调用存储过程？Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

sql:

ALTER PROCEDURE [dbo].[gup_p_filtermoney]

BEGIN

CREATE TABLE #temp1(

[code] [varchar](10) NOT NULL,

[name] [varchar](50) NULL,

[run_time] [datetime] NOT NULL,

[amounts] [decimal](18, 5) NULL,

[counts] [int] NULL,

)

declare @day_count int ,@daysuc_count int

declare @days int

declare @run_time datetime

set @days=15

set @run_time=GETDATE()

select @day_count= count(update_time) from

(select distinct update_time

from dde_fund_flow

where DATEPART(hour,update_time) =16

and DateDiff(dd,update_time,getdate())<=@days ) a

set @daysuc_count=@day_count/2 +2

Insert into #temp1 (code,name,run_time,amounts,counts)

select a.share_code AS code,a.name ,convert(varchar(23),@run_time,120) as run_time ,a.amounts,b.counts from

(select share_code,name ,SUM (net_amount) as amounts

from dde_fund_flow , shares

where dde_fund_flow.share_code =shares.code

and DateDiff(dd,update_time,getdate())<=15

and DATEPART(hour,update_time) =16

group by share_code,name

having SUM (net_amount)>0 ) a ,

(select share_code, count (net_amount) as counts from dde_fund_flow

where DateDiff(dd,update_time,getdate())<=15

and net_amount >0 and DATEPART(hour,update_time) =16

group by share_code

having count (net_amount) >1 ) b

where a.share_code=b.share_code

and b.counts>@daysuc_count

order by counts desc ,a.amounts desc

select * from #temp1

end

button click :

Dim sql,sqlstr As String

Dim P_Cmd As new SQLCommand
Dim P_Dt,Pr_Dt As DataTable
\'sql ="select * from shares"
P_Cmd.C
P_Cmd.CommandText ="Exec gup_p_filtermoney "
P_Dt=P_Cmd.ExecuteReader()
返回空记录，存储过程应返回记录集，大家有没有碰到过啊

我在 sql 后台执行 exec gup_p_filtermoney

是有数据的，返回#temp1 表数据。