I have a table of 224000 rows that I query with a GROUP BY to generate some 200 separate queries.
I select and run these 200 queries which give me 200 result grids.
I am able with SSMSboost/Script Data to export All Grids to a single xml file, which is almost a 1 GB is size, with a separate tab for every grid. The file is too large for Excel to handle well.
However, what I need is for each grid to be exported to it's own separate file, resulting in 200 xml files, and for each filename to be based on a value in the grid (first value of specific column).
Can this be achieved?