SQLCMD query adding spaces between charactures
Posted on 2011-04-21
I have an SQL file like this:
set heading off;
set linesize 10000;
set pagesize 0;
set trimspool on;
set feedback off;
Select somthing || ',' ||
somthing_else || ',' ||
It is run from a batch file like this:
sqlplus user/pw@server @daily.sql
I:\ is a remote drive on a server
When I run this from one machine, the results are fine.
When tested on another machine t h e r e s u l t s h a v e s p a c e s b e t w e e n e a c h c h a r a c t u r e .
U m m m . . . ?
How can I fix this? I want to see the results without the extra spaces, but keep any original spaces. I assume it has something to do with the local machine settings, not the files, since both PC's use the same files from the server.