A big table has been created for me and it has 22 columns. I made a few set of table just to normalize it so I ended up having 7 tables (sql server 12).
Source: Table A
Destination: Table a1, a2, ..., a7
How can I select few columns from table A and insert them in a1, and few in table a2, and etc? is it possible to do this using one Select INTO command? or do I need to create a cursor?