<div>
<div class="content wysiwyg-content">
I am calling my stored procedure but I need to take the results of my Sproc <br />
and send the results as a csv file in an email <br />
<br />
How exactly would I do this? <br />
<br />
&nbsp;I am calling this job inside my stored procedure <br />
<br />
Exec msdb.dbo.sp_send_dbmail <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@profile_name = 'PSDB01@xxxx.com',<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@recipients = @EmailRecipients,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@subject = 'Account_Report',<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@body = 'File(s) attached'
</div>
</div>


I am calling my stored procedure but I need to take the results of my Sproc 
and send the results as a csv file in an email 

How exactly would I do this? 

 I am calling this job inside my stored procedure 

Exec msdb.dbo.sp_send_dbmail 
			@profile_name = 'PSDB01@xxxx.com',
			@recipients = @EmailRecipients,
			@subject = 'Account_Report',
			@body = 'File(s) attached'

Wrapping an email in a stored procedure

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.