asp与存储过程的问题

lihuijian 2009-08-24 12:05:55

DECLARE @s varchar(8000)
SET @s = ''
SELECT @s = @s + ',[' + rukulb_mc + ']=(case rukulb_mc when '''+rukulb_mc+''' then (case rukulb_xz when 2 then cksl else rksl

end) else 0 end )'
from sm_rukulb
--print @s
exec ('select info.peij_no,peij_mc '+@S+' ,peij_kc from kucshp_info info,kucshp_zk zk,sm_rukulb lb,(
select peij_no,chru_zy,sum(peij_rs) rksl,sum(peij_cs) cksl from kucshp_mx where chru_rq >=''2009-07-15'' and chru_rq

<=''2009-08-21'' group by peij_no,chru_zy) mx
where info.peij_no = mx.peij_no and lb.rukulb_mc = chru_zy and info.peij_no = zk.peij_no and peijlb_mc =''南宁八菱''')
以上在查询分析器中运行正常
把上边的内容转成asp中查询的语言，如下：
s=""
Set rs1= Server.CreateObject("ADODB.RecordSet")
rs1.open ("SELECT '"&s&"' = '"&s&"' & ', rukulb_mc =(case rukulb_mc when rukulb_mc then (case rukulb_xz when 2 then cksl else rksl end) else 0 end )' from sm_rukulb"),sconn,1,1 到这行提示错误
rs1.close
Set srs= Server.CreateObject("ADODB.RecordSet")
srs.open ("select info.peij_no,peij_mc '"&S&"' ,peij_kc from kucshp_info info,kucshp_zk zk,sm_rukulb lb,(select peij_no,chru_zy,sum(peij_rs) rksl,sum(peij_cs) cksl from kucshp_mx where chru_rq >=''2009-07-15'' and chru_rq <=''2009-08-21'' group by peij_no,chru_zy) mx where info.peij_no = mx.peij_no and lb.rukulb_mc = chru_zy and info.peij_no = zk.peij_no and peijlb_mc =''南宁八菱''"),sconn,1,1

提示错误为
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
不能使用空白的对象或列名。如果必要，请使用一个空格。

/x_kehu.asp，行 351

=============================================
请问各位大侠是不是我的asp中的查询语句写错了，还是什么原因，
因为调用存储过程老是出错（还没学会怎么调用，按网上搞的老提示错误，就想了这个办法，把查询写到asp中）

敬请详细解答，谢谢

...全文