select @tabname='VW_ZYJGK_YS'
set rowcount 100
exec(' select a.idm " ",a.ypmc "名称",a.ypgg "规格",
a.cjmc "产地", a.yfcl "存量",
convert(numeric(14,4),a.ylsj*a.zyxs/a.ykxs) "单价",
a.zydw "单位",b.name "执行科室",a.ypdm " ",
a.py " ",a.wb " ",a.zyxs " ",a.ykxs " ",
a.ksdm " ",a.dxmdm " ",c.name "药品属性",a.ypbz " ",
a.zyzfbz " ",a.zyzfbl " ",a.xmlb " ",
a.jxdm " ",a.yjqr " ",b.name " ",
a.ggdw " ",a.ggxs " ",a.yzxm " ",
a.gg_idm " ",a.yzgl " ",
a.cgyzbz " ",a.dybz " ",
a.yzbz " ",a.lcxmmc " ",ybkzbz " ",
a.lcxmdm " ",a.lcxmdj " ",a.lcxmmc" " ,a.memo " ",a.idm "*a.idm" , c.ypbz " ", a.zyflzfbz " ","" as " ","" as " ","" as " ",0 " ",0 " ", a.cfypbz " ",a.zbybz " " ,
a.ypdm1 " ",a.sqddm " ",a.mzdw " ",a.mzxs " "
from '+@tabname+' a (nolock),YY_KSBMK b (nolock),
YY_SFDXMK c (nolock)
where '+@pyfield+' like "%'+@searchstr+'%"and'+@wheresql)
楼下测试无法通过,应该是where a.syfw=0 and '+@pyfield+' like "%'+@searchstr+'%"and'+@wheresql)
|