SQL QUERY FORMATTER HOW TO

Everything is going well, but one thing I can't overcome is that a blank row is being inserted below the column headers and the data set inserts below that. I am able to format the template with the needed header spaces, the bold column headers with right font. Process involves creating a template excel that is permanently stored in a Template folder, and then during execution a copy of the template xlsx is moved to a folder where it can be written to by the OPENDATASOURCE query. ', Status from '- Send the e-mail with the query results in attachĮxec statuses = switched to using INSERT OPENDATASOURCE instead of OPENROWSET since the former doesn't require having a linked server set up. Select nocount on select CT_Reason_Description ' + + Create the query, concatenating the column name as an alias Create the column name with the instrucation in a variable below generates query and emails dataset as .csv attachmentĬREATE PROCEDURE.

SQL QUERY FORMATTER HOW TO

I don't know how to do it and if someone else does, can you provide an example to emulate? (column headers start on 11th row, are bold, Tahoma 8 Font, and column header cells highlighted in grey). xlsx report! xlsx template for how formatting is to look is attached. Now I need to modify it to send dataset as a formatted. I already have a working stored procedure that exports sql query data set into a .csv file and emails it.

Sql query formatter