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.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…