<div>
Count the selected rows. &nbsp;If the count is &gt;0, export the query. &nbsp;If the count is 0, export a single record with the message in it.
</div>


Count the selected rows.  If the count is >0, export the query.  If the count is 0, export a single record with the message in it.

<div>
What does your query look like?
</div>


<div>
Can you please post the code you are using to retrieve the data.
</div>


Can you please post the code you are using to retrieve the data.

<div>
<div class="content wysiwyg-content">
I use a SP to extract a CSV file daily, once in a while I get a blank file when there is no matching query; how do I add a line that simply says &quot;No data today&quot; &nbsp;and add it to my file when there is a blank file so my user can see the message..
</div>
</div>


I use a SP to extract a CSV file daily, once in a while I get a blank file when there is no matching query; how do I add a line that simply says "No data today"  and add it to my file when there is a blank file so my user can see the message..

Add a data line when the SQL SP creates a blank file

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.