Get column name, first record name

[Leszek]

Hello!
Can someone help me?

How to get for some records (like 0 or 1) column names?

Example:
I've got a table, that looks

server | parameter1 | parameter2 | parameter3
----------------------------------------------
server1 | 0 | 0 | 1
server2 | 1 | 0 | 1
server3 | 1 | 1 | 0

I want to have all with 0 value:

server | parameter
---------------------
server1 | parameter1
server1 | parameter2
server2 | parameter2
server3 | parameter3

So i need first record from each row and column name for it.
Can someone help me? Please...
I started with .NET in this week...

 

[Eliyahu Goldin]

It's an sql question. Following select will do.

select server, 'parameter1' as parameter from myTable where parameter1=0
union
select server, 'parameter2' as parameter from myTable where parameter2=0
union
select server, 'parameter3' as parameter from myTable where parameter3=0

Eliyahu

 

[Leszek]

Thank you very much!
I thought, tha i must look into row, check each value, get the first record,
column name for this value and put it into a table