Skip to Content
0
Former Member
May 23, 2008 at 02:16 PM

Restructure internal table and populate into database table

103 Views

Hi,

I have some

Account Entity Category period1value pd2value

10 A C 100 200

Now I need to populate it into database table having structure

Account Entity Category period Value

10 A C 1 100

10 A C 2 200

that means instead of having values of all the periods in the same row we insert a column period in the database table which means we denormalize the table and new rows are created for each entry.

Pleadse help

Ankit