Output Column names in each Row along with the row Value

From: Yas <yasar1@xxxxxxxxx>
Date: Fri, 29 Jun 2007 03:09:59 -0700

Hello,

I was wondering if anyone can help me figure something out.
Is it possible to do a querey in MS SQL server and have the results
returned so that each result in each row is preceeded by the column
name?

eg. instead of usual output -> colName1, colValue1,
colName2,colValue2,colName3,colValue3 ?

Also I would like to only have this for certain columns ie in the
above example only for columns 2 and 3

Thank you! :-)

Yas

.

Follow-Ups:
- Re: Output Column names in each Row along with the row Value
  - From: M A Srinivas

Prev by Date: Re: problem in date comparison
Next by Date: Scope in derived tables
Previous by thread: Re: XML INTO SQL
Next by thread: Re: Output Column names in each Row along with the row Value
Index(es):
- Date
- Thread