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