Hi,

I am using an order by on a standard Insert .. Select into query. It is listed below. When I put an order by into the select statement, it gives an error of 'Incorrect syntax near the keyword 'order'.' However, if I remove the order by it works fine. If I run the select statement by itself, it works fine. Also, eventhough the records where inserted by a previous insert trigger, they still are not defaultly in the same order....