SQL Server : return column names based on a record's value

Question

Hi I have one table.I want tha column names based on column values |Field1 |Field2 |Field3 |Field4 | |-------|-------|- ------ |-------| | 1 | 0 | 0 |1 | now i want the field name contain zero.Is this POssible in sql server. What I have tried: I've been trying to do various joins against sys.columns (and sys.tables) but so far to little avail.

Mayank · Answer

http://dba.stackexchange.com/questions/91961/how-to-get-the-column-name-having-a-particular-value-from-a-sql-server-table

Manas Mohapatra · Answer

Your question is same as stackoverflow: http://stackoverflow.com/questions/27285569/sql-server-return-column-names-based-on-a-records-value http://stackoverflow.com/questions/33758294/retrieve-the-value-with-column-name-and-corresponding-values-in-t-sql

Nitin Sontakke · Answer

No is the answer but please don't take it. Could you please elaborate what exactly you are trying to achieve? And does the solution should be on server side only? (because it is possible to do it once the result set is in C# (Java) because there you get all the metadata.