<div>
here we go:<br />

<pre><code id="code-101575">select mese, enero, febreo
  from yourtable
union all
select 'total', sum(enero), sum(febro)
  from yourtable
</code></pre>
</div>


here we go:


select mese, enero, febreo
  from yourtable
union all
select 'total', sum(enero), sum(febro)
  from yourtable


<div>
select sum(enero),sum(febreo)
</div>


<div>
<div class="content wysiwyg-content">
how do Add a total row to in a &nbsp;store procedure, my query show;<br />
meses enero febreo<br />
item1 &nbsp; 100 &nbsp; &nbsp; 200<br />
item2 &nbsp; 150 &nbsp; &nbsp; &nbsp;250<br />
I need to show<br />
meses enero febreo<br />
item1 &nbsp; 100 &nbsp; &nbsp; 200<br />
item2 &nbsp; 150 &nbsp; &nbsp; &nbsp;250<br />
total &nbsp; &nbsp; 250 &nbsp; &nbsp; 450<br />

</div>
</div>


how do Add a total row to in a  store procedure, my query show;
meses enero febreo
item1   100     200
item2   150      250
I need to show
meses enero febreo
item1   100     200
item2   150      250
total     250     450


Add a total row in store procedure

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.