Click here to Skip to main content
13,300,331 members (50,750 online)
Rate this:
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 1:37am

1 solution

Rate this: bad
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.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.171207.1 | Last Updated 10 Jan 2013
Copyright © CodeProject, 1999-2017
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