I need to retrieve rows of data from a few columns within a table.
I need to automate this.
I've decided to use a batch file.
The command I've been running is.
osql -S .\sqlexpress -E -i "C:\Users\user.name\Desktop\eventdatetime24hr.sql" -o "C:\Users\user.name\Desktop\queryOut.csv"
It produces an output that looks like this:
As you can see, the output looks gross.
I need to feed it into another application, however, I can only do this is there is a separate cell for each column and row of data.
I don't know how to do this, can anyone please assist?
The columns are: eventdatetime, eventid, sNarrative