如何对 SQL 存储过程的 col 结果求和 [英] How to do sum of col results from a SQL Stored Procedure

问题描述

我有一个存储过程，结果如下:

I have a stored procedure and it results like this:

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

推荐答案

如果没有你的列名，这有点棘手，但它会是这样的:

without your column names it's a little bit tricky, but it would be something like:

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

这篇关于如何对 SQL 存储过程的 col 结果求和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！