Save query results to a file or by copying leads to bad or missing data

[peterrow]

Issue Type: Bug

Issue 1:

• Run a query or stored procedure that returns multiple resultsets, each with no more than 10 columns
• Click button on the right of the results pane to save to Excel
• Open in Excel
• PROBLEM: Only the 1st result set has been saved.
• ASSERTION: Save each result set to a new sheet within the same file.

Issue 2:

• Run a query that returns a result set with several columns (9 in my case) with a few rows (16 in my case)
• Click in one of the cells of the resultset, press Ctrl-A to select all data.
• Right click on the results grid and chose the "Copy with headers" option.
• Open Excel, click cell A1, press Ctrl-V to paste the data.
• PROBLEM: The header row is first but then the rows of data are in a some form of random order rather than the order they appeared in the resultset in Azure Data Studio.
• FURTHER INFO: Performing the same actions in SQL Server Management Studio and the header and rows of data paste into Excel in the order as they appear in the result set, thus it's a bug in Azure Data Studio

Azure Data Studio version: azuredatastudio 1.13.0 (cacd481, 2019-11-02T00:40:05.147Z)
OS version: Windows_NT x64 10.0.18363

System Info

Item	Value
CPUs	Intel(R) Core(TM) i7-6700K CPU @ 4.00GHz (8 x 4008)
GPU Status	2d_canvas: enabled flash_3d: enabled flash_stage3d: enabled flash_stage3d_baseline: enabled gpu_compositing: enabled multiple_raster_threads: enabled_on native_gpu_memory_buffers: disabled_software oop_rasterization: disabled_off protected_video_decode: unavailable_off rasterization: enabled skia_deferred_display_list: disabled_off skia_renderer: disabled_off surface_synchronization: enabled_on video_decode: enabled viz_display_compositor: disabled_off webgl: enabled webgl2: enabled
Load (avg)	undefined
Memory (System)	31.92GB (19.58GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions (3)

Extension	Author (truncated)	Version
ssmskeymap	kev	1.1.0
import	Mic	0.12.0
profiler	Mic	0.9.0

[oappelt]

Same/similar thing happened to me.
Resultset with 18 columns and 23 rows.
click on cell -> "select all" (or click upper left grid corner) "copy with headers"
After pasting into Excel, not only were the rows jumbled - but also the column values got shuffled around.

Pretty sure this problem is new in 1.13.

Version: 1.13.0
Commit: cacd481
Date: 2019-11-01T23:20:53.295Z
VS Code: 1.38.0
Electron: 4.2.10
Chrome: 69.0.3497.128
Node.js: 10.11.0
V8: 6.9.427.31-electron.0
OS: Linux x64 4.15.0-64-generic

[Charles-Gagnon]

1 I'm closing as a duplicate of #4399. We currently don't support saving multiple result sets to the same file.

2 is a duplicate of #8210

This has been fixed on the insiders build that you can install now - otherwise it'll be available in the next stable release. Sorry about the inconvenience!

[peterrow]

1 I'm closing as a duplicate of #4399. We currently don't support saving multiple result sets to the same file.

2 is a duplicate of #8210

This has been fixed on the insiders build that you can install now - otherwise it'll be available in the next stable release. Sorry about the inconvenience!

We know you don't support saving multiple result sets but the fact that you have at least 2 issues now asking about it and both suggesting a fairly obvious and simple way it could be done seems like you should add it to your backlog.