Do it in a SP
or select for a view that has an order by
or even try
insert into myexternal_table (....)
select blah from myInternal _table where PK > 0

This may use the index to build the result set and get the records in that
order.
This may work for any field that has an index on it.

Just 3 ideas, haven't tested any of them.

JAC.

""Mike Grover"" <mike@...> wrote in message
news:NCBBILCEMLDCJOMKGJJKOEPDEHAA.mike@......

> I need to do a select on one table and insert the records into another
> in a particular order.
>
> the second table is a external Table.
>
> Any ideas?
>
> mike
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>