SELECT "Q1" AS QuNo, Q1 AS Result FROM [SourceTable] UNION SELECT "Q2" AS QuNo, Q2 AS Result FROM [SourceTable] UNION SELECT "Q3" AS QuNo, Q3 AS Result FROM [SourceTable]
Robert Stocks Web Developer Noko internet business soultions -----Original Message----- From: Angela Lam [mailto:angela@;kaisen.co.uk] Sent: 08 November 2002 10:25 To: ActiveServerPages Subject: Splitting a single row into multiple records 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.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
