New answers tagged export
The simplest method would be a 2 step approach : Log the output of stored procedure to a physical table in the sql server database. e.g. insert into dbo.X_sp_name_out exec dbo.sp_name Use BCP OUT or SQLCMD to export data to text file. (Optional.. but important to manage table growth) Have a purging process to purge out the old records or before next ...
I've changed my plan, instead of outputting to an excel file I'm going to build a web app that presents the requested data to the user, provides the ability to modify it if required along with the functionality to export to excel or csv format.
Top 50 recent answers are included