Export SQL query to excel with multiple worksheets and custom headers
What I need to do is, a client wants to have a report in an excel doc with multiple worksheets with custom headers. I have tried SSRS 2008 Report Builder 2.0 but naming worksheets is not available with SSRS 2008 Report Builder 2.0. I have tried bcp in SQL Server Management Studio, but am not able to export it into multiple worksheets. I have put the queries into temp tables, is there a way to export those queries into the same excel doc but different worksheets with a different header for each worksheet.
Like this
Notice how each worksheet has a different name and a different header.
Is this possible to do with SQL or is there a workaround for SSRS 2008 Report Builder 2.0?
You could use SQL Server Integration Services 2008R2 (SSIS) to do this. SSIS has an Excel Data Flow Destination that accepts a worksheet name as a parameter. You could construct your SSIS package to populate the various worksheets of a spreadsheet this way.
- Audit table update trigger does not work using a stored procedure
- Entity Framework | Sequence contains more than one matching element
- How can I alter column name in Sql server
- How to partition into batch of records with max batch size limit
- LOAD DATA INFILE error in MySQL
- Cannot perform an aggregate function on an expression containing an aggregate or a subquery with STRING_AGG
- Perform a row count of each table in my list of tables
- Entity Framework Core 3.1.6 Item With Same Key Has Already Been Added
- Split a string with no delimiters into columns
- Each GROUP BY expression must contain at least one column that is not an outer reference
- Add custom columns to pivot table
- Parameterized raw sql query much slower than query with actual values
- SQL Server database backup restore on lower version
- Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
- How can I create a unique constraint on my column (SQL Server 2008 R2)?
- Summation of a column using certain conditions
- Natural join in SQL Server
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to Renumber Set/Subset of Table Based on Numbering of A Second Table
- Using Azure Devops deploy release to multiple repos
- SQL Server Cursor vs WHILE loop
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- Can ransomware encrypt a mounted SQL database? Hypothetical
- Grant user DDL permissions on specific schema
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Collecting data from a joined table based on condition(s) in the joined table
- Stored procedure for auto generating roll no?