[dba-SQLServer] Views don't sort

jwcolby jwcolby at colbyconsulting.com
Fri May 20 12:31:42 CDT 2011


I apparently ignored your top 99.999% part.

When I went back in to my view and selected top 1 million (very big) it did in fact return a sorted 
data set.


John W. Colby

On 5/20/2011 1:07 PM, Francisco Tapia wrote:
> So something like:
> Create View vwSomeView AS
> Select TOP 99.9999 percent Field1, Field2, Field3
>> From tblSomeTable
> Order by Field3
> does not sort field3?  what are your results when you just select * from
> vwSomeView ?  are the results sorted in your results display in management
> studio?
> -Francisco
> <http://bit.ly/sqlthis>
> On Fri, May 20, 2011 at 10:02 AM, jwcolby<jwcolby at colbyconsulting.com>wrote:
>> One of the things I am trying to do is use SQL Server to speed up my
>> applications.  The theory is that I can hand off the heavy lifting to SQL
>> Server and just get back result sets.  Of course this works in terms of
>> joins and filters in a view, but even though I specify a sort in a view,
>> when the result set hits the other end (Access in my case) it is unsorted.
>> Views have the ability to do sorts, so why is the data returned by a view
>> into a third party app, or even into another view in SQL Server unsorted?
>>   Is there a way to tell sql server to return sorted data?
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com

More information about the dba-SQLServer mailing list