I have a view that I want to display in a particular order so I added "ORDER BY <column> DESC" to the end of my view logic. When I run it as a query or even when I execute the view in the modify window, it appears correctly ordered. But, when I just "Open View", it's not ordered how I want it. I don't know why it doesn't order it when you open the view, but how can I resolve this issue?
I'm populating data in an Excel worksheet and I want it to be in a particular order. My SELECT statement pulls data from my view for an OPENROWSET call. I've altered the statement, adding the bold code below per your suggestion, but it still isn't coming out in any sort of order when I open the Excel file.
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\TEMP.xls;','SELECT * FROM [WSC 2nd day App$]') select * from SQL_TEMP1 order by [Days Referral Open] DESC