注意:当前为视频教学,文本教学可在视频下方查看!
代码:
sfql=case when (select count(1) from sdbs045 where charindex(bs04502,ym00532)>0)=0 then '未运算' when (select sum(isnull(bs04605,0)*isnull(st03704,1)-isnull(bs04608,0)) from sdbs045 left join sdbs046 on bs04602=bs04501 left join sdst037 on st03702=bs04603 and st03703=bs04604 where charindex(bs04502,ym00532)>0)<=0 and (select count(1) from sdym006 where ym00604=ym00501)=0 then '是' else '否' end









