Hi there,

I am trying to transfer data from one table into a new format table.

The data needs to come from a table like:

Q1    Q2    Q3
---   ---   ---
5     5     8


And needs to be transformed into this format

QuNo  Result
----  ----
Q1    5

Q2    5

Q3    8

Does anyone have SQL statement that can do this?

Thanks in advance,
Angela

---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to