"Joe" <joconnor@adelmantravel.com> wrote in message
news:uLFs0qVSHHA.1016@TK2MSFTNGP04.phx.gbl:

> If I execute the following command in a DTS package will the rows be
> inserted in that order?
>
>
>
> SELECT *
>
> INTO TableB
>
> FROM TableA
>
> ORDER BY COL3, COL2, COL5
>
>
>
> And when I perform the following select statement would they still be
> sorted
> in that order?
>
>
>
> SELECT *
>
> FROM TableB
>
>
>
>
>
> I say that they will not necessarily be in the same order but a coworker
> disagrees and I can't seem to find the answer anywhere