求一存储过程分类小计、合计

[KLL]

http://topic.csdn.net/u/20101211/18/8923fb2f-b8be-4b85-ba51-0f35f3c0affc.html?seed=1511394456&r=70522368#r_70522368

[飘零一叶]

体力活

[华夏小卒]

详情请看这里5楼，6楼

http://topic.csdn.net/u/20101212/10/1188633f-1412-4672-8b19-f4c2702e0e9b.html?seed=1402534221&r=70531085#r_70531085

[pt1314917]

CREATE PROCEDURE chaxun  
@a char
AS
exec('select m.daima as ''代码'',m.mingcheng as ''名称'',m.xianjia as ''现价'',m.zhangfu as ''涨幅'',
cast((((m.xianjia)/(x.zg)-1)*100) as decimal (18,2)) as ''5日跌幅'',
cast((((m.xianjia)/(s.zg)-1)*100) as decimal (18,2)) as ''25日跌幅'',
cast((((m.xianjia)/(x.zd)-1)*100) as decimal (18,2)) as ''5日涨幅'',
cast((((m.xianjia)/(s.zd)-1)*100) as decimal (18,2)) as ''25日涨幅'',
cast(((x.zg-m.xianjia)/(x.zg-x.zd)*100) as decimal (18,2)) as ''5日威廉指标'',
cast(((s.zg-m.xianjia)/(s.zg-s.zd)*100) as decimal (18,2)) as ''25日威廉指标'',
cast((x.zf) as decimal (18,2)) as ''5日振幅'',
cast((s.zf) as decimal (18,2)) as ''25日振幅'',
cast((((m.xianjia)/(x.ax)-1)*100) as decimal (18,2)) as ''5日均线'',
cast((((m.xianjia)/(s.ax)-1)*100) as decimal (18,2)) as ''25日均线'',
cast((x.zz) as decimal (18,2)) as ''5日量能'',
cast((s.zz) as decimal (18,2)) as ''25日量能'',
cast(((x.qj-1)*100) as decimal (18,2)) as ''震荡区间'',
cast((cast(m.zongliang as decimal)/cast(n.zongliang as decimal)-1) as decimal (18,2)) as ''当日增量'' from
(select b.* from
(select a.* ,
px = (select count(1) from meirishuju where daima = a.daima and date > a.date) + 1
from meirishuju a ) b
where b.px=1) m,
(select b.* from
(select a.* ,
px = (select count(1) from meirishuju where daima = a.daima and date > a.date) + 1
from meirishuju a ) b
where b.px=2) n,
(select b.daima,max(zuigao) zg,min(zuidi) zd,avg(zhengfu) zf,max(zuigao)/min(zuidi) qj,avg(xianjia) ax,
sum(zhangfu*zongjine)/avg(zongjine) zz from
(select a.* ,
px = (select count(1) from meirishuju where daima = a.daima and date > a.date) + 1
from meirishuju a ) b
where b.px between 1 and 5
group by b.daima ) x,
(select b.daima,max(zuigao) zg,min(zuidi) zd,avg(zhengfu) zf,max(zuigao)/min(zuidi) qj,avg(xianjia) ax,
sum(zhangfu*zongjine)/avg(zongjine) zz from
(select a.* ,
px = (select count(1) from meirishuju where daima = a.daima and date > a.date) + 1
from meirishuju a ) b
where b.px between 1 and 25
group by b.daima ) s
where m.daima=n.daima and m.daima=x.daima and m.daima=s.daima
and m.daima in (select daima from daima where biaoji in(2))
and n.zongliang <>0
order by '+@a+' desc')
GO

[pt1314917]

贴错了。不好意思。。

[dawugui]

看了,感觉用SQL来做,太困难,还是用程序去实现吧.

[-晴天]

可以根据要获得的数据一段一段地写查询语句.不过,比较麻烦,最好在程序里用报表来做.