Open in Excel
Published 29 October 2019
Including SSMS query results in emails or report documents in am more time-consuming task than it sounds. Using the built-in Copy with Headers… results in poorly formatted, tab-separated text. Copying the results from the text output mode requires use of a fixed-width font.
Instead, simply highlight the required results (the whole grid, or a subset of adjacent columns), right click and use SQL Prompt's Open in Excel to copy grid results into an Excel document, format them as required, and then either send the Excel document, or copy and paste from there into the mail, or any other document.