H,
how to Extract SQL Query result to Excel sheet in SQL server,
query runns every day its scheduled, so I need to keep all my query result in Excel sheet, Later I will do FTP.
Please suggest me is there any way to do in SQL Server.
Note :- Not using Result to File in Management studio, I need to know using any scripts in Sql
Example - Select * from temp --> result should go to Excelsheet