Hi @SVA
Do you want to send the result in excel format?
You seem to give little information.
Can this thread help you?
Best regards,
Percy Tang
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi
How to send a query output in excel with a formatted way in runtime by using EXEC msdb.dbo.Sp_send_dbmail.
Hi @SVA
Do you want to send the result in excel format?
You seem to give little information.
Can this thread help you?
Best regards,
Percy Tang
How to send a query output in excel with a formatted way
You simply can not.
What do you expect, SQL Server is a database server, not an application server.
Use an application server or at least a PowerShell script to generate & format an MS Excel file; SQL Server can't do this.