在线等45分钟，Sybase sql语句，大家看看是否可行！（我不想用存储过程）

[hammer_shi]

insert into ywsjk.dbo.DXDDJSMX
case
where select jsfs from jtsjk.dbo.DXYJJM where ztfw='''+ztfw+''' and hmlx='''+hmlx+'''='0'
then select dxddm,'''+lsh+''',''0'',''01'',''1'',fwhm,1,'''',a.jsbl*b.fyxj,''0'','''+czygh+''',getdate(),null,null,null,null,null,null,null
from ywsjk.dbo.DXDYSHK b,jtsjk.dbo.DXYJJM a
where b.dxddm='''+dxddm_1+''' and convert(char(8),b.lrrq,112)<'''+jzrq+''' and b.jssx=''0'' and b.hmlx='''+hmlx_1.items[hmlx_1.itemindex]+'''
when select jsfs from jtsjk.dbo.DXYJJM where ztfw='''++''' and hmlx='''+hmlx+'''='1'
then select dxddm,'''+lsh+''',''0'',''01'',''1'',null,1,'''',a.jsje*count(b.hm),''0'','''+czygh+''',getdate(),null,null,null,null,null,null,null
from ywsjk.dbo.DXDYSHK b,jtsjk.dbo.DXYJJM a
where b.dxddm='''+dxddm_1+''' and convert(char(8),b.lrrq,112)<'''+jzrq+''' and b.jssx=''0'' and b.hmlx='''+hmlx_1.items[hmlx_1.itemindex]+'''

[johnsonrao]

太乱了，只能说没不合法的关键字，应该可以用
---------------------

[hammer_shi]

这样的结构对么？
（主要是insert 语句可以用case么？）
insert into ywsjk.dbo.DXDDJSMX
case
where select jsfs from jtsjk.dbo.DXYJJM='0'
--上面的保证只能有一条数据
then select dxddm,a.jsbl*b.fyxj........
from ywsjk.dbo.DXDYSHK b,jtsjk.dbo.DXYJJM a
where .............
when
select jsfs from jtsjk.dbo.DXYJJM='1'
--上面的保证只能有一条数据
then select dxddm,a.jsje*count(b.hm)
from ywsjk.dbo.DXDYSHK b,jtsjk.dbo.DXYJJM a
where ...................