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

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..
Abdul KhanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
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.
0
awking00Information Technology SpecialistCommented:
What does your query look like?
0
Fernando SotoRetiredCommented:
Can you please post the code you are using to retrieve the data.
0
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
You can add your final query data in temp table .And before exporting data just check. If temp table has data export it if not insert data with message no data found  in first column.

Hope it will help you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Abdul KhanAuthor Commented:
Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.