Database

//I'm sorry but I have to get your database dirty with this test table
CREATE TABLE TEST(F1 NUMBER(1),F2 NUMBER(1),F3 NUMBER(1))
/
INSERT INTO TEST VALUES(1,2,3)
/

SELECT X.C1 AS "COLUMN NAME", Y.C2 AS "VALUE"
FROM
(SELECT column_name AS C1 from user_tab_columns where table_name = 'TEST') X,
(
SELECT  F1 AS C2 FROM TEST
UNION
SELECT F2 FROM TEST
UNION
SELECT F3 FROM TEST
) Y
/

COLUMN NAME                         VALUE
------------------------------ ----------
F1                                      1
F1                                      2
F1                                      3
F2                                      1
F2                                      2
F2                                      3
F3                                      1
F3                                      2
F3                                      3

9 rows selected.

<br />
--And you can keep out of my database please<br />
DECLARE @Tbl Table(F1 int,F2 int,F3 int)<br />
<br />
INSERT INTO @Tbl VALUES(1,2,3)<br />
<br />
SELECT *<br />
 FROM @Tbl<br />
 <br />
 <br />
SELECT 'F1' Col,	F1 [Value]<br />
FROM @Tbl T	<br />
UNION <br />
<br />
SELECT 'F2' Col,	F2 [Value]<br />
FROM @Tbl T	<br />
UNION <br />
<br />
SELECT 'F3' Col,	F3 [Value]<br />
FROM @Tbl T	<br />

SELECT 'My Column Name 1' FROM MyTable
WHERE MyColumn1 = 1 UNION
SELECT 'My Column Name 2' FROM MyTable
WHERE MyColumn2 = 1 UNION

Mycroft Holmes wrote:

--And you can keep out of my database please
DECLARE @Tbl Table(F1 int,F2 int,F3 int)

set @Var = @@Rowcount<br />
Select @Var Records

Mycroft Holmes wrote:

I suspect this is a really badly designed table

Mycroft Holmes wrote:

What happens when 2 or more column have a value?

A
B
C