本帖最后由 P878Kg 于 2016-11-17 10:47 编辑
49874
49875
49876
给存付过程传参,参数控制是下拉书,用单元格获取参数返回的值也正常,但无法返回多TABLE,如果直存储那里直接用字符串能返回多TABEL
49879
存储返回语句:
select wwcs=round((ISNULL(YJH,0)-ISNULL(ljwc,0))/1000,0),ljwct=ROUND(ljwc/1000,0),* from View_yxsjhcx where n=@n and y=@y AND YHH='SYSTEM' and YJH>0
order by wwcs
select ywymc, round(LJWC/YJH,2)*100 as wcl,1-round(LJWC/YJH,2) as wwcl from View_yxsjhcx where n=@n and y=@y AND YHH='SYSTEM' and YJH>0
order by wcl desc
select round(sum(LJWC)/sum(YJH),2)*100 as wcl,(1-round(sum(LJWC)/sum(YJH),2))*100 as wwcl from View_yxsjhcx where n=@n and y=@y AND YHH='SYSTEM' and YJH>0
order by wcl desc
select bm, round(sum(LJWC)/sum(YJH),2)*100 as wcl from View_yxsjhcx
where n=@n and y=@y AND YHH='SYSTEM' and YJH>0
group by bm