strSql += " case when (SELECT count(1) FROM officedba.SellSend AS sod WHERE sod.FromType = '1' AND sod.FromBillID = s.ID)>0 then '已发货' ";
strSql += " when (select count(1) yp from dbo.SetlerBills sb ";
strSql += " where sb.ContractID=s.ContractNo and sb.Yprice/s.TotalFee*100>=s.TalkProcess)>0 then '已达到' ";
strSql += " else '未达到' end ispass ";这是查询的内容,加是否到达为检索条件
strSql += " when (select count(1) yp from dbo.SetlerBills sb ";
strSql += " where sb.ContractID=s.ContractNo and sb.Yprice/s.TotalFee*100>=s.TalkProcess)>0 then '已达到' ";
strSql += " else '未达到' end ispass ";这是查询的内容,加是否到达为检索条件
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货