数据库sybase11的
CREATE PROCEDURE dbo.p_ss;1
@ls_ysnd varchar(10),
@ls_ysdeptid varchar(10)
AS
BEGIN
create table #t_ssk
( fyysbmzeid varchar(10) null,
ysnd varchar(4) null,
xmid varchar(10) null,
ysname varchar(30) null,
csname varchar(30) null,
kzbs varchar(2) null,
ys_deptid varchar(10) null,
deptwz varchar(30) null,
deptname varchar(30) null,
zemoney decimal(18,2) null,
zjmoney decimal(18,2) null,
z_ysmoney decimal(18,2) null,
z_zysmoney decimal(18,2) null,
)
insert into #t_ssk(fyysbmzeid,ysnd,xmid,ysname,csname,
kzbs, ys_deptid,deptwz,deptname,zemoney,zjmoney,
z_ysmoney,z_zysmoney )
SELECT v_viem_bmzecx.fyysbmzeid,
v_viem_bmzecx.ysnd,
v_viem_bmzecx.xmid,
v_viem_bmzecx.ysname,
v_viem_bmzecx.csname,
v_viem_bmzecx.kzbs,
v_viem_bmzecx.ys_deptid,
v_viem_bmzecx.deptwz,
v_viem_bmzecx.deptname,
v_viem_bmzecx.zemoney,
v_viem_bmzecx.zjmoney ,
( SELECT sum( v_xzy_ysmx.zcmoney )
FROM v_xzy_ysmx
WHERE ( v_xzy_ysmx.ys_deptid = v_viem_bmzecx.ys_deptid ) AND
( v_xzy_ysmx.xmid = v_viem_bmzecx.xmid )
) as z_ysmoney,
( SELECT sum( v_xsy_ysmx.zcmoney )
FROM v_xsy_ysmx
WHERE ( v_xsy_ysmx.ys_deptid = v_viem_bmzecx.ys_deptid ) AND
( v_xsy_ysmx.xmid = v_viem_bmzecx.xmid )
) as z_zysmoney
FROM v_viem_bmzecx
WHERE v_viem_bmzecx.ysnd = @ls_ysnd and
v_viem_bmzecx.ys_deptid = @ls_ysdeptid
select * from # t_ssk
END
我的存过代码是这样的，但是报错
说什么 # not found ....的 请高手帮助看看是哪里错了！
------解决方案--------------------
select * from #t_ssk
------解决方案--------------------
加个空格干嘛？