bcp in

[Geetha]

I bcp out data from a source table

Truncate table from destination

Then bcp in data to the destination table

When I do a select * from the destination table the order in which it displays
is different from the order in which it displays in the source

Note: This table has some nonclustered unique index on a field. The destination
table displays in that order.

Thanks for your help in advance

[Rune Bivrin]

The order in which a SELECT returns rows is undetermined by definition. If
you require a specific order, use ORDER BY.

Rune Bivrin

"Geetha" <gelangov@hotmail.com> wrote in news:3d760bce$1@10.1.10.29:

>
> I bcp out data from a source table
>
> Truncate table from destination
>
> Then bcp in data to the destination table
>
> When I do a select * from the destination table the order in which it
> displays is different from the order in which it displays in the
> source
>
> Note: This table has some nonclustered unique index on a field. The
> destination table displays in that order.
>
> Thanks for your help in advance