Posted by Yas on 06/29/07 10:09

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

• Next in forum: Scope in derived tables
• Prev in forum: Re: problem in date comparison
• Thread view: Output Column names in each Row along with the row Value

[Reply to this message]