<div>
try using the &quot;order by&quot; on your query definition, in Excel
</div>


try using the "order by" on your query definition, in Excel

<div>
Where do you set the &quot;order by&quot; within the query definition?
</div>


Where do you set the "order by" within the query definition?

<div>
<div class="content wysiwyg-content">
I have a view written for SQL Server 2008. &nbsp;I order by a field called Fiscal Year. &nbsp;When I run the vew in Management Studio, it runs with the fiscal years in ascending order. &nbsp;When I add a connection to an Excel spreadsheet to pull this view in, the view returns the rows out of order. &nbsp;I am not sure why this is. &nbsp;I definitely am not sure how to resolve.
</div>
</div>


I have a view written for SQL Server 2008.  I order by a field called Fiscal Year.  When I run the vew in Management Studio, it runs with the fiscal years in ascending order.  When I add a connection to an Excel spreadsheet to pull this view in, the view returns the rows out of order.  I am not sure why this is.  I definitely am not sure how to resolve.

SQL View to Excel

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.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.