Thanks, Naomi. The workaround (specifying any top number but 100 percent) will solve the problem for now.

Does anybody know if SQL 2005 SP2 corrected this issue? I think my 2005 install might only be SP1...


>I found this article http://oakleafblog.blogspot.com/2006/09/sql-server-2005-ordered-view-and.html
>
>>Hi all,
>>
>>Got a weird one here. I create a *simple* view in the SQL 2005 View Designer:
>>

>>SELECT ALL
>>guiUniqueID, chvCollectionKey, chvCaption, chvClassLibrary,
>>chvClassName, chvParentNode, inyNodeLevel, insNodeSequence, 
>>inyNodePlacement, bitExternalProcess, dtmCreated, chvCreator, dtmUpdated, chvUpdater
>>FROM Control.TreeViewNodes
>>ORDER BY inyNodeLevel, insNodeSequence
>>

>>When I execute the code in the View Designer, all is well. However, when I execute the view from either a query or by right-clicking the view name and choosing Open View, the ORDER BY clause does not function correctly. I get the correct quantity and selection of rows that I expect -- they're just not in the correct order.
>>
>>What stupidly simple thing am I doing wrong here?
>>
>>TIA,