I have sql MainTable with 12 Columns and 100 Rows A to L
Primary Key A
Foreign Key B
I need to extract columns C - L and Insert them in a new RowTable.
The RowTable has the following schema
Primary Key ID = Identifier
Foreign Key fkey_A reference Primary Key A MainTable
Foreign Key fkey_B reference Foreign Key A MainTable
ColumnObject = varChar
ColumnObject will contain each values of C - L column from MainTable.
I am looking for a store-procedure that could help me achive this objective.