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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-10 : 08:17:50
|
| Raxit writes "Hi guys,I am facing some problem using the isql statement.The output of my query is position specific ...and i need some fields to start at a particular position..so any deviation on the field position is not acceptable.I am using isql to get the output of a stored procedure in a text file, however in my text file the fields start fromposition 2, instead of position 1. It means that isql inserts leading spaces before the record.please let me know if anyone knows a work-arround for this.ThanksRaxit" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-10 : 13:11:56
|
| Could you show us what the output looks like and what it should look like?Tara |
 |
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-06-10 : 15:59:38
|
| You can add -s on the command line to tell isql not to use a seperator between columns (or specify a different seperator than space). That will remove the space at the beginning but it also remove the space between columns.You should also use osql which replaces isql in SQL 2000. It is generally backward compatible and it supports more options. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-10 : 16:13:52
|
| Lets's see...I would store the output of the sproc (how much data?) in to a table and then bcp out the table and drop the tableIt will give you more options...too bad you can't bcp a sproc...or can you?test time (doubt it..think I may have already tried it)Brett8-) |
|
|
|
|
|
|
isql command problem