If you open a table using SSMS, the rows (usually) are ordered by the clusterd index. It's highly recommended to add an ORDER BY clause to the SQL string returned by the SSMS "Open table" command
Lutz
A pessimist is an optimist with experience. How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]