Hi,

First the query what you have specified is itself seems problem.

1. it uses subquery. - Try to avoid subqueries.

2. it uses leftouter join - I don't know the no...

The bcp commad is as follows:

bcp user_table1 in data.txt -S servername -U username -P password -c -t` -C 65001

if use -w while creating txt and as well dumping the text...