Re: Query Analyzer-Result to Text
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Thu, 1 Feb 2007 00:40:48 -0500
You should do the calculation first and then cast it. I thought you were
talking about character columns anyway.
--
Andrew J. Kelly SQL MVP
"HLong" <HLong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:061E730D-C6D1-4F64-BC0B-2F105F7E3203@xxxxxxxxxxxxxxxx
Thank you. CAST() works fine for some columns but not for all, specially
calculated columns. I tried (cast(columnA .....)*cast(columnB.....)) but
it
didn't work.
"Andrew J. Kelly" wrote:
I don't know how to change the title. I never print directly. I typically
use the grid and copy and paste to Excel. You can issue a CAST() in the
select on the wide columns to make them as small as you want.
--
Andrew J. Kelly SQL MVP
"HLong" <HLong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:338E2DC7-46DD-4E06-A0CB-BB89B8C5C343@xxxxxxxxxxxxxxxx
Hi, I am trying to print the query result directly from the query
analyzer. I
am having two probles. One - I can't find a way of changing the
<untitled>
title on the result, so I have to put it by hand. Is there a way of
changing
the title? Two - Some of the fields on the tables were created too
wide,
more than the should have been, so the result column are too wide for
the
data. Is there a way of narrowing the result columns? I would really
appreciate any help
.
- Prev by Date: Re: Help with SQL 2005 and Sourcesafe 6
- Next by Date: Re: 5 Day Backup Maintenance Plan Help?
- Previous by thread: Re: Help with SQL 2005 and Sourcesafe 6
- Next by thread: Re: 5 Day Backup Maintenance Plan Help?
- Index(es):
Relevant Pages
|
