Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hi to all,
I want to insert data from one table to another table. But structure of both table is different. One is column wise and 2nd is row wise. eg is shown below.
 
table 1::
 
id parameter id name result Date Patient_Id
 
1 1 Weight 80 2012-09-30 1
 
2 2 Systolic Pressure 65 2012-09-30 1
 
table 2:
 
id parameter id Weight Systolic_Pressure Date Patient_Id
 
1 1 80 65 2012-09-30 1
 
I have table 1 and want to insert data in table format like above format..
 
Please help me how it is possible...
Posted 10-Jan-13 0:37am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Iterate through the data from the first table, collect all data for the new row of second table, then insert the record.
 
You can do this in SQL by using a cursor.
Or you can do this in your program using a foreach loop. (I recommend this for you)
 
Maybe somebody else wants to write you the actual code, but I don't.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Schatak 394
1 OriginalGriff 355
2 _Amy 115
3 Sergey Alexandrovich Kryukov 109
4 Andreas Gieriet 100
0 OriginalGriff 7,097
1 Sergey Alexandrovich Kryukov 5,623
2 Maciej Los 3,504
3 Peter Leow 3,373
4 DamithSL 2,505


Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 10 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100