Hi Triveni,

You can do 5 separate selects and UNION them.

Regards,
Albert


--- Triveni_Gupta
<mssqldba-ezmlmshield-x9489704.[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
>
>


MS Sql Server LazyDBA home page