Forum Discussion
Adagio
Frequent Contributor
So I'm trying to run a SQL query on production data which would flag some transactions, export them in a spreadhsheet and save it in a location. A notification goes out to someone to review these faulty transactions.
I can still do all of this but not so quick. When the program reads the query results row by row and copies to the excel, it takes 2 minutes/1000 rows. I'm trying to make it <10 sec.
Thank you
Abhi
tristaanogre
6 years agoEsteemed Contributor
Yeah, in script code, I don't think you're going to get to that <10 sec requirement. You'll need to execute some sort of SQL server side command to dump the table off into an Excel file. Some sort of SSIS job or mssql command line I think is what you're going to end up needing to do.
Related Content
- 9 years agohxiao
- 6 years agonimishbhuta
Recent Discussions
- 2 days agoGane195