I'm not sure I understand what you are asking

Unless you have an order by statement in the view, the order is likely to be somewhat random

Russ

Which order the data gets exported i.e. which row order.

A table is an unordered set and unless you specify an ORDER BY then you
have no real way of predicting which rows will be output in which order.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Indra" <anonymous (AT) discussions (DOT) microsoft.com> wrote