Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Help for isql

Author  Topic  dlau Starting Member 2 Posts Posted - 2001-10-25 : 19:03:02 What I want to achieve is to do a complex select command to get data out from different tables and output it into a txt file. This is on SQL7.0 for example John,Smith,39,123 St John Rd,555-1234 Bob,Waugh,23,456 Mt Wellington St,555-4567 All these data are in different tables. I tried isql /Sserver /ddirdb /n /h-1 /w400 /s, /Usa /P"" - iinput.txt -ooutput.txt output look like this John ,Smith ,39 ,123 St John Rd ,555-1234 Bob ,Waugh ,23 ,456 Mt Wellington St ,555- 4567 (2 rows affected) If I use isqlw /Sserver /ddirdb /n /s, /Usa /P"" -iinput.txt -ooutput.txt output look like this First_Name,Last_Name,Age,Address,Phone John,Smith,39,123 St John Rd,555-1234 Bob,Waugh,23,456 Mt Wellington St,555-4567 (2 rows affected) What I want is just the data in the output file ie John,Smith,39,123 St John Rd,555-1234 Bob,Waugh,23,456 Mt Wellington St,555-4567 Is there any other way of doing other than using isql? Any ideas???? Dave