Exporting data to excel I want to execute some stored procedure and I want to export that result to Excel. How can Do that ? I'm new to SQL. any help or tutorials about this will appreciated.
Couple of ways that I know of


Run procedure in ssms, then copy results into excel (make sure to turn on the option to copy column headers in tools,options,query results)
Create a SQL server integration services (SSIS) package to run the procedure and write the results to a CDC or excel file.
If you have SQL server reporting services (SSRS) you can create a report to run the procedure and display the results, then from the report website you can export the report to excel/csv. This can also be scheduled through SSRS subscriptions.