Check the knowledge base at Microsoft I remember something on cross tab queries in SQL Server.
Pete Lundrigan Media Resources Center Academic Web Support 316.978.7759 http://www.mrc.twsu.edu/ [EMAIL PROTECTED] -----Original Message----- From: Angela Lam [mailto:angela@;kaisen.co.uk] Sent: Friday, November 08, 2002 4:25 AM 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]
