Hi Everyone,
Perhaps you can give me some good advice...I am trying to export data to a fixed length flat file from an openquery from another system and for some reason the data is skewed all through the file...Can anyone help? Or has anyone run into this problem before...If you see below the data is skewed across the entire file when I open it into ultraedit after creating the file...multiple columns
281689XXXX11606 281689XXXX11606
5283XXXX4411809 5283XXXX4411809
2718XXX1959 2718XXX1959
541XX43 541XX43
492 492
select * from openquery(td,'
SELECT
cast(c.NAME as char(40)),
cast(c.AREN as char(9)),
cast(b.AID as char(20)),
cast(c.AADR as char(40)),
cast(c.AUNT as char(40)),
cast(c.AENCY as char(30)),
cast(c.ARET as char(2)),
cast(c.ARNZ5 as char(5))
FROM Table1 a
JOIN Table2 b on a.ARID = b.AACID
JOIN Table 3 c ON a.ARD = c.AROD
WHERE a.TYPID = ''PRIM''
AND a.ASTATUSID = "DONE"
')
492