Hi,

I am moving some data from a table to a text file using BCP. The data is
created in a temporary table and is then moved to a global temporary table in
the order of ID (this is the identity field in the temporary table). However,
in the text file the last row gets inserted somewhere in the middle. I don't
know what am I doing wrong.
Any insight will be greatly appreciated. Thanks.

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
Convert *= / =* to outer joins (ANSI compliant)
SQL Include Empty Months
2005: How to SELECT a Bitmask?