mounty95
asked on
SQL View to Excel
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.
try using the "order by" on your query definition, in Excel
ASKER
Where do you set the "order by" within the query definition?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.