save results in a proper format

Whenever i save results in query analyser or even when i run osql and use
the -o switch to output to a file, the results always appear in an
unreadable format.
Is there any way where i can view the entire row in one line as opposed to
multiple lines.. So if i have 10 rows as the output of a query , i would
like to see
10 straight lines that i can scroll from left to right in notepad along with
the column names obviously.. But everytime those 10 rows are on 100 lines
and its really unreadable...
Is there a better way to save this from QA and also other switches to be
used for osql ? Or maybe there is some options in notepad or wordpad to
make it appear better .. Please suggest..( Note that i do not have my word
wrap on ) .. But i guess you guys who saved results before know what im
talking about
Thankshi hassan
I dont know whats going wrong with, but i save my result in following way
using query analyzer
first i on "show result in grid" by pressing Ctrl+D
then execute the query
click on left, top corner of the grid and copy the contents
paste in notepad or excel sheet .
this work fine
Ansari
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#4P2CqCgEHA.384@.TK2MSFTNGP10.phx.gbl...
> Whenever i save results in query analyser or even when i run osql and use
> the -o switch to output to a file, the results always appear in an
> unreadable format.
> Is there any way where i can view the entire row in one line as opposed to
> multiple lines.. So if i have 10 rows as the output of a query , i would
> like to see
> 10 straight lines that i can scroll from left to right in notepad along
with
> the column names obviously.. But everytime those 10 rows are on 100 lines
> and its really unreadable...
> Is there a better way to save this from QA and also other switches to be
> used for osql ? Or maybe there is some options in notepad or wordpad to
> make it appear better .. Please suggest..( Note that i do not have my word
> wrap on ) .. But i guess you guys who saved results before know what im
> talking about
> Thanks
>|||Well Id like to just save it without do the cut and paste.. Also i have jobs
that use osql to output to text files that does not format right
"M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
news:OFr4KUDgEHA.3548@.TK2MSFTNGP09.phx.gbl...
> hi hassan
> I dont know whats going wrong with, but i save my result in following way
> using query analyzer
> first i on "show result in grid" by pressing Ctrl+D
> then execute the query
> click on left, top corner of the grid and copy the contents
> paste in notepad or excel sheet .
> this work fine
> Ansari
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:#4P2CqCgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Whenever i save results in query analyser or even when i run osql and
use
> > the -o switch to output to a file, the results always appear in an
> > unreadable format.
> >
> > Is there any way where i can view the entire row in one line as opposed
to
> > multiple lines.. So if i have 10 rows as the output of a query , i
would
> > like to see
> >
> > 10 straight lines that i can scroll from left to right in notepad along
> with
> > the column names obviously.. But everytime those 10 rows are on 100
lines
> > and its really unreadable...
> >
> > Is there a better way to save this from QA and also other switches to be
> > used for osql ? Or maybe there is some options in notepad or wordpad to
> > make it appear better .. Please suggest..( Note that i do not have my
word
> > wrap on ) .. But i guess you guys who saved results before know what im
> > talking about
> >
> > Thanks
> >
> >
>|||hi Hassan
Well, it was misunderstanding...You can use BCP utility to export your data.
here is the sample one
BCP "SELECT * FROM NORTHWIND.DBO.ORDERS" queryout
c:\orders.txt -c -r\n -t\t -Usa -Pansari -Smudasaransari\mma
BCP is a command line utitlity and you may see the BOL for detail of
swtiches I have used there. remmber that switches are case sensitive.
hope this will solve your problem.
Thanks
Ansari
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ef748pIgEHA.596@.TK2MSFTNGP11.phx.gbl...
> Well Id like to just save it without do the cut and paste.. Also i have
jobs
> that use osql to output to text files that does not format right
> "M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
> news:OFr4KUDgEHA.3548@.TK2MSFTNGP09.phx.gbl...
> > hi hassan
> > I dont know whats going wrong with, but i save my result in following
way
> > using query analyzer
> >
> > first i on "show result in grid" by pressing Ctrl+D
> > then execute the query
> > click on left, top corner of the grid and copy the contents
> > paste in notepad or excel sheet .
> >
> > this work fine
> >
> > Ansari
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:#4P2CqCgEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > Whenever i save results in query analyser or even when i run osql and
> use
> > > the -o switch to output to a file, the results always appear in an
> > > unreadable format.
> > >
> > > Is there any way where i can view the entire row in one line as
opposed
> to
> > > multiple lines.. So if i have 10 rows as the output of a query , i
> would
> > > like to see
> > >
> > > 10 straight lines that i can scroll from left to right in notepad
along
> > with
> > > the column names obviously.. But everytime those 10 rows are on 100
> lines
> > > and its really unreadable...
> > >
> > > Is there a better way to save this from QA and also other switches to
be
> > > used for osql ? Or maybe there is some options in notepad or wordpad
to
> > > make it appear better .. Please suggest..( Note that i do not have my
> word
> > > wrap on ) .. But i guess you guys who saved results before know what
im
> > > talking about
> > >
> > > Thanks
> > >
> > >
> >
> >
>