我有一个存储过程,其结果如下:
Governors AUTO 07313570121 1 3.69 2.01 2.01 1.68 83.58%
Governors AUTO 07319354850 1 2.79 1.8 1.80 0.99 55.00%
Governors AUTO 07480400400 1 17.69 9.71 9.7117 7.9783 82.15%
Governors AUTO 07723100038 1 2.89 1.55 1.55 1.34 86.45%
Governors BEER 01820000031 6 4.69 23.34 3.888 0.8 20.57%
Governors BEER 01820000051 6 4.69 23.34 3.888 0.802 20.63%
Governors BEER 01820000106 1 6.39 4.93 4.93 1.46 29.61%
我想总结如下:
Governors AUTO 4 27.06 15.07
Governors AUTO 13 13.07 51.61
没有你的列名,这有点棘手,但它会是这样的:
CREATE TABLE #MyTable
(
col1 varchar(50),
col2 varchar(4),
col3 varchar(11),
col4 int,
col5 decimal(18,2),
col6 decimal(18,2),
col7 decimal(18,2),
col8 decimal(18,2),
col9 decimal(18,2) --might need to be varchar if the % sign comes back
)
insert into #MyTable
Exec storedProc
select col1, col2, sum(col4), sum(col5), sum(col7)
FROM #MyTable
GROUP BY col1, col2
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)