注意:當前為視頻教學,文本教學可在視頻下方查看!
代碼:
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









