<div>
You can use the OSQL utility to do that. It is a command like utility that can run against your SQL server, store it as a batch file and schedule it through windows scheduler.<br />
Here is more info on the OSQL utility: <a href="http://technet.microsoft.com/en-us/library/aa213090(SQL.80).aspx" rel="ugc">http://technet.microsoft.c<wbr />om/en-us/l<wbr />ibrary/aa2<wbr />13090(SQL.<wbr />80).aspx</a><br />
Hope this helps.<br />
P.<br />

</div>


You can use the OSQL utility to do that. It is a command like utility that can run against your SQL server, store it as a batch file and schedule it through windows scheduler.
Here is more info on the OSQL utility: http://technet.microsoft.com/en-us/library/aa213090(SQL.80).aspx [http://technet.microsoft.com/en-us/library/aa213090(SQL.80).aspx]
Hope this helps.
P.


<div>
Is there a way to combing multiple reports into one single report?
</div>


Is there a way to combing multiple reports into one single report?

<div>
Check this links out:<br />
<a href="http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/ea62917d-238f-40ec-bbb4-15217e258191" rel="ugc nofollow">http://social.msdn.microso<wbr />ft.com/For<wbr />ums/en-US/<wbr />sqltools/t<wbr />hread/ea62<wbr />917d-238f-<wbr />40ec-bbb4-<wbr />15217e2581<wbr />91</a><br />
P.<br />

</div>


Check this links out:
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/ea62917d-238f-40ec-bbb4-15217e258191 [http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/ea62917d-238f-40ec-bbb4-15217e258191]
P.


<div>
<div class="content wysiwyg-content">
I would like to have a stored procedure to product an output report to a text file. &nbsp;Is this possible?<br />
<br />
Table1<br />
<br />
PN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MonthGenerated<br />
--- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ---------------------<br />
12345 &nbsp; &nbsp; &nbsp; &nbsp; Apr<br />
22345 &nbsp; &nbsp; &nbsp; &nbsp; Apr<br />
11111 &nbsp; &nbsp; &nbsp; &nbsp;Mar<br />
22222 &nbsp; &nbsp; &nbsp; &nbsp;Mar<br />
11211 &nbsp; &nbsp; &nbsp; Jun<br />
<br />
<br />
Output report<br />
<br />
&quot;Monthly Generated Report&quot;<br />
<br />
Month &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Counts<br />
------- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;---------<br />
Mar &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
Apr &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<br />
Jun &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1
</div>
</div>


I would like to have a stored procedure to product an output report to a text file.  Is this possible?

Table1

PN               MonthGenerated
---               ---------------------
12345         Apr
22345         Apr
11111        Mar
22222        Mar
11211       Jun


Output report

"Monthly Generated Report"

Month                  Counts
-------                  ---------
Mar                     2
Apr                    2
Jun                     1

SQL Output Report

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.