selectquery.png

<div>
Did you tried to run the query and you can see that it is actualy sorted? Then you should be able to just replace it in the code below and generate an output file that will be ON the server where you run the query and not on the client from where you run it - it MUST be sorted...<br />
<br />
<br />
exec master..xp_cmdshell N'sqlcmd -E -Q&quot;select * from server_name.dba_name.schem<wbr />a_name.tab<wbr />le_name&quot; -h-1 -s&quot;,&quot; -W -o&quot;c:\output.txt&quot;', no_output <br />
<br />
for more info on sqlcmd switches and impact in output file format please see:<br />
<a href="http://msdn.microsoft.com/en-us/library/ms162773.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms162773.aspx</a><br />

</div>


<div>
<div class="content wysiwyg-content">
I have a query that I would like to export to a text file using SQL Server Import and Export Wizard. &nbsp;The query itself has the columns to sort by, but upon export the text file is not sorted. &nbsp;<br />
<br />
What is an easy way to export the query sorted? <br />
<br />
Thanks...
</div>
</div>


I have a query that I would like to export to a text file using SQL Server Import and Export Wizard.  The query itself has the columns to sort by, but upon export the text file is not sorted.  

What is an easy way to export the query sorted? 

Thanks...

SQL table export to text file sorted by 2 columns

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.