Order By - 02-21-2006 , 10:52 AM
How would i add order by to the syntax below:
"Select * Into ETCLog_holding from etclog where box# BETWEEN " & Box1 &
" and " & Box2
i have tried adding it after Box2 but it doesnt work.
Re: Order By - 02-21-2006 , 04:39 PM
(pkruti (AT) hotmail (DOT) com) writes:
However, it is a fairly pointless thing to do. If you expect data in
ETCLog_holding to have a certain order, you are forgetting the fact
that tables are unordered sets.
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at