Return
-
Title
Not all rows of data are being exported to Excel when using Stored Procedures to generate the dataset -
Description
Connected to SQL Server 2012 on Toad Data Point 3.3 to perform an export template using a Stored Procedure to generate a dataset and save it to an Excel (.xlsx) file. The results is almost 22,000 rows; however the resulting Excel file only writes 1,465 records.
Viewing the event log it's writing the data in blocks of 5,000:
Writing rows 0 - 5000Writing rows 5000 - 10000Writing rows 10000 - 15000Writing rows 15000 - 20000Writing rows 20000 - 21465But it seems to overwrite each sequence before and only write down to the Excel file the last block which equates to 1465 rows.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.