sql server (microsoft): Hi guys and gals,

I need help with a table I have. It looks something like this:

Log | Var1 | Var2 | Var3 | .....| Var300
-----------------------------------------------------
1 | Data
2 | Data
3 | Data

I want to rework the table so it reads:

Log | Var | Data
-----------------------
1 | Var1 | Data
1 | Var2 | Data
1 | Var3 | Data

and so on....

The reason I'm doing this is because I have a lot of data about the
Variables (Var1, Var2, Var3....) in a seperate table and I want to
link them together.

Thanks for your help,

Andy

[quoted text, click to view]
I meant Changing a field name into a row... sorry.

[quoted text, click to view]

[quoted text, click to view]

See http://en.wikipedia.org/wiki/Entity-Attribute-Value_model
(particularly the "Downsides" section) for general background.

That said:

insert into new_table (Log, Var, Data)
select Log, 'Var1', Var1 from old_table
union
select Log, 'Var2', Var2 from old_table
union