Attach query result as file

Hi, I have been struggling for the above task since two days I want following format need to do. So please help me i tried a lot to get that format. I want those columns result in each column separately and should be wrapped.

Use Quotes around data so as it does not think embedded commas in field is not new columns. Or use a different column delimiter, such as tab or pound. I am also facing the same issue. My query is doing well with attachment the problem is that it is not including all the records from result set.

There are more than records the same query returns from table but when I check in mail, the attachment has only records everytime I send the mail. Do you have any idea? This behaviour is a bug in the code which limits the total size of the attachment. This has been resolved in some versions of SQL Server. Your solution worked great and exported into the correct. Do you know a work around for this? Hi Alex I found same problem every column data was placed in one column in CSV file so please help me.

How we can remove the number of rows affected the CSV is showing at the end of file. Please help. Here is my query:.

I also would like to share what worked for me, with less effort. It might help the others too. Hi Alex, Can be add formatting like making headers bold, adding Borders in the resulted excel file. Can we also add one more result sheet in the same resulted excel. It is not an Excel file, so you should give it a.

Your email address will not be published. A performance comparison. By Alex Whittles Published April 23, A nice little nugget today for anyone who uses SQL dbmail to send data in csv attachments. The only problem, how do you insert a header line when using dbmail? So how do we do this in SQL? A Fan on July 31, at said:. Glen on October 10, at said:. Janardhan on October 21, at said:. Mez Pattni on December 1, at said:. Shawn on December 10, at said:.

Richard on February 16, at said:. Alex on February 17, at said:. Palak Patel on March 15, at said:. Venkatesh on August 21, at said:. Ani on March 13, at said:. Best, Ani. Ani on March 18, at said:. Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed. Dennes can improve Data Platform Architectures and transform data in knowledge.

View all articles by Dennes Torres. Subscribe for more articles Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed. Simple Talk. SQL Server Merge. SQL Drop. SQL Server Pivot. Create an Azure storage account. Upload files to Azure storage container. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to send a query result in CSV format? Ask Question. Asked 8 years, 10 months ago. Active 1 year, 10 months ago. Viewed 62k times. Thanks in advance.

Improve this question. Based on Requirement.