本帖最后由 P878Kg 于 2016-11-17 10:47 编辑 给存付过程传参,参数控制是下拉书,用单元格获取参数返回的值也正常,但无法返回多TABLE,如果直存储那里直接用字符串能返回多TABEL 存储返回语句: 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 |
最佳回答 |
||||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|