Question: how to export data from sql server 2008 r2 to excel using query?
Answer: you can right click on database in the Object Explorer and select Database->Tasks->Export Data . An SQL Server Import and Export Wizard dialog opens and you will be able to export data from any table or query to the file or another destination.