Hi Triveni,

Perhaps you would want to try something like this:

SELECT CONVERT (varchar (255), IntColumnName) AS
[SomeColumnName]

UNION

SELECT CONVERT (varchar (255), Str30ColumnName) AS
[SomeColumnName]

UNION

SELECT CONVERT (varchar (255), DateColumnName) AS
[SomeColumnName]

Regards,
Albert

(Remember to reply to all, if you want to send to the
list too)

--- Triveni_Gupta <[Email address protected] wrote:

> Does not work, selecting individual columns in each
> select throws error in converting datatype,
> other way if I do select * from table and then union
> them, giving same resutls. any other help
>
> -----Original Message-----
> From: Albert van Biljon
> [mailto:[Email address protected]
> Sent: Friday, January 27, 2006 4:22 PM
> To: Triveni_Gupta
> Subject: Re: Columns in rows format
>
>
> **A LazyDBA.com subscriber has responded to your
> lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this
> email,
> **and removed any attachments, and kept your email
> address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see
> your email address as normal
> **Anything below this line is the original email
> text
>
>
> Hi Triveni,
>
> You can do 5 separate selects and UNION them.
>
> Regards,
> Albert
>
>
> --- Triveni_Gupta
> [Email address protected]
> wrote:
>
> > Hi Experts
> >
> > I need my columns in rows format. I have 5 columns
> > and want it to be shown as rows in QA window.
> > Any help would be highly appreciated.
> >
> > Thanks in advance.
> >
> > Cheers
> > Triveni
> >
> >
> >
>
---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> > JUST REPLY
> > Website : http://www.LazyDBA.com
> > To unsubscribe:
> > http://www.lazydba.com/unsubscribe.html
> >
> >
> >
> >
> > DISCLAIMER:
> > This email (including any attachments) is intended
> > for the sole use of the intended recipient/s and
> may
> > contain material that is CONFIDENTIAL AND PRIVATE
> > COMPANY INFORMATION. Any review or reliance by
> > others or copying or distribution or forwarding of
> > any or all of the contents in this message is
> > STRICTLY PROHIBITED. If you are not the intended
> > recipient, please contact the sender by email and
> > delete all copies; your cooperation in this regard
> > is appreciated.
> >
> >
> >
> >
>
---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> > JUST REPLY
> > Website : http://www.LazyDBA.com
> > To unsubscribe:
> > http://www.lazydba.com/unsubscribe.html
> >
> >
>
>
>
>
>
>
> DISCLAIMER:
> This email (including any attachments) is intended
> for the sole use of the intended recipient/s and may
> contain material that is CONFIDENTIAL AND PRIVATE
> COMPANY INFORMATION. Any review or reliance by
> others or copying or distribution or forwarding of
> any or all of the contents in this message is
> STRICTLY PROHIBITED. If you are not the intended
> recipient, please contact the sender by email and
> delete all copies; your cooperation in this regard
> is appreciated.
>
>


MS Sql Server LazyDBA home page