<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to export the results of a store procedure to an excel file.<br />
<br />
The store procedure is made up of about 30 select statements that return mostly count or sum values e.g.<br />
<br />
select count(blah) from table_blah where blah = 'blah blah' <br />
<br />
I am a novice at DTS and it only passes the first result from the first select statement - how do I get all the results?<br />
<br />
Cheers - and thanks for solving this headache!
</div>
</div>


Hi,

I am trying to export the results of a store procedure to an excel file.

The store procedure is made up of about 30 select statements that return mostly count or sum values e.g.

select count(blah) from table_blah where blah = 'blah blah' 

I am a novice at DTS and it only passes the first result from the first select statement - how do I get all the results?

Cheers - and thanks for solving this headache!

Export Store Procedure Results to Excel

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.