Sql Query Saved results (CSV) look like a row of integers coma separated.

Question

Sql Query Saved results (CSV) look like a row of integers coma separated.

cvoronin

Newbie

Points: 2
More actions
May 6, 2009 at 12:10 pm

#71511

Hi guys does anyone know if my file is corrupt? I dont have the database anymore, I saved query results in SQl studio as .csv... but if i open it its just bunch of integers coma separated instead of actual db values... The file is very large, 500MB to be exact.
Here is one row:
37035062,11061231,36,59255,25027180,25310173,14043537,14043537,27894B93-5A48-423A-BE28-330EF1D56AE6,2008-04-10 07:50:59.630,79.90,0,9.95,0.00,1,6,,2008-04-10 00:00:00.000,0,0,564146779,NULL,1,0.00,2008-06-02 00:00:00.000,127
I have no idea whats going on. Can anyone suggest a way to fix this? If its possible at all that is.
Thanks,
Chris

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

That looks like a perfectly good CSV to me. What's the problem?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

LutzM SSC Guru Points: 107049 More actions · Answer 2

Hi,

that's exactly what the csv format is supposed to to:

save the data as Comma Separated Values.

What data do you expect?

Regarding your statement "I don't have the database anymore,..": How about a backup?

Didn't you test the usability of your csv files before "getting rid" of the original database?

The data can -more or less- easily be reimported into a SQL database; assuming you know the structure of the fields. For details please refer to OPENROWSET or sp_addlinkedserver in BOL. Altogether it sounds really confusing... :ermm:

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

cvoronin Newbie Points: 2 More actions · Answer 3

Thanks guys,

But I did test the file in excel before. It's an old backup.

Instead of coma separated numbers its supposed to show usernames, log action names, etc... (words not numbers)... Thats what I was referring it. The computer that had the db is dead.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 4

cvoronin (5/6/2009)
Thanks guys,
But I did test the file in excel before. It's an old backup.
Instead of coma separated numbers its supposed to show usernames, log action names, etc... (words not numbers)... Thats what I was referring it. The computer that had the db is dead.

Sorry, but those columns do not appear to be in that CSV.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]