Michael Valentine Jones (10/12/2010)
Since the source of data is a TXT file created with BCP, why don't you just order the TXT file in the order you want by using a query with an ORDER BY as the source for the BCP command?This will almost certainly be faster than the other methods mentioned, and will be much simpler.
No argument there.
Alvin RamardMemphis PASS Chapter[/url]
All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]