jwcolby
jwcolby at colbyconsulting.com
Fri May 20 12:31:42 CDT 2011
Francisco, 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. Thanks! John W. Colby www.ColbyConsulting.com 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 > >