I have a simple task. I have a query which needs to be executed in SQL server. This will be executed daily at least once. The output of the query execution should be exported in the form of an excel sheet and placed in a file share. Format of Excel file name should be dummyExcel_dd-Mon-yy_HH:MM:SS . Every time code runs it will create a new file.

For example, consider that the query output will have following columns : EmployeeId , EmployeeName, Salary.

What is the easiest way to achieve it in MS SQL Server. I am not sure how to do it.