469,951 Members | 2,485 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,951 developers. It's quick & easy.

query analyzer returning messed up data

ftw
I am using SQL7 Query Analyzer. A simple select * from myMLSview and
then I save results as a .csv file has the commas messed up in quite a
few places. The data is messed up before I save it to the .csv file. So
there are blank spaces being added here and there causing them to read
as 'add comma' when saving to .csv format. Even the column data is
messed up... example: ,photo_mod_time,photo_mo,d_date, should read
,photo_mod_time,photo_mod_date,
I have a view on a remote MS-SQL7 Server, the view has about 200
columns and the data returned from the my querys can be from 10 to 25MB
in size. Connection is via Roadrunner/cable. Should I use another
method, maybe command line? Any suggestions?

Jul 23 '05 #1
3 1332
I have no idea why the commas are messed up, but in general bcp.exe or
DTS would be a better way to create a .CSV - it's probably faster, and
you don't have to do anything manually as you can just script it and
run a batch file. There are more details in Books Online.

Simon

Jul 23 '05 #2
ftw
Do you know any good net sources of info to learn DTS?

Jul 23 '05 #3

"ftw" <sp**********@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Do you know any good net sources of info to learn DTS?


http://www.sqldts.com/

And Books Online, of course.

Simon
Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Saiyan Vejita | last post: by
1 post views Thread by justinjoylife | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.