Tips:Inserting rows in a specified order (SQL)
From sasCommunity
The SQL INSERT statement does not permit use of an ORDERED BY clause to control the order in which the new rows are stored. To work around this limitation, define a named view and include the ORDERED BY clause in its definition, then invoke the view in the INSERT statement.
Submitted by Howles. Contact me at my Discussion Page.
....read more
