insert into dm_qdjlkh (id,nd,yf,xm,pq)
select (@nd+@yf+xt_yh.id),@nd,@yf,xt_yh.id,(select top 1 pqmc from dm_dmda where dm_dmda.dmdd = xt_yh.id) from xt_yh where bm_id = '100002'第一个错
select (@nd+@yf+xt_yh.id),@nd,@yf,xt_yh.id,(select top 1 pqmc from dm_dmda where dm_dmda.dmdd = xt_yh.id) from xt_yh where bm_id = '100002'第一个错
--公式(:[(Y01-Z02)/Z03+Z05]*Z01 ***Z01、Z02、Z03、Z04、Z05分别为:权重、基本值、得分比值、得分上限、基础分数)
select distinct dm_qdjlkh.xm as xm,
case when ((select top 1 dfbz from dm_kzczdf )*((select sum(czje) from dm_kzczxse,dm_dmda where nd = @nd and yf = @yf and qdjl = dm_qdjlkh.xm and dm_kzczxse.dmbh = dm_dmda.dmbh and dm_dmda.sfcjkzcz = '1' )/(select count(*) from dm_dmda where dm_dmda.dmdd = dm_qdjlkh.xm and dm_dmda.sfcjkzcz = '1') - (select top 1 kzczjbz from dm_kzczdf ))=0)
then 0 else
查找其它类似地方,加上top 1.