1.The best way you can use inbuilt Export to excel feature of sql server to get excel file even you want to fetch using sql query for filter result.
2.You can create excel file using BCP command with sql query.
3.you can get excel using OPENROWSET with using Microsoft.Jet.OLEDB.4.0.
4.Simple way you just select query in sql sever management studio and copy result set from result pane and paste into new excel sheet.
Regards & thanks
I want export data from sql server to new excel using sql query. I want to Copy/Paste method.