SQL Table

[OuTCasT]

Is it possible to create a table with column names from another tables column information ?

for instance i had 2 tables earnings and earningsDescrip tions.
in the earningsDescrip tion table i have a column called DescriptionName s which is filled in by the user during the companies setup.

now i want those names in the EarningsDescrip tions table column to be populated in the Earnings table as there own seperate columns and not in 1 column underneath each other. ?

Is this possible ?

[debasisdas]

First copy only the structure and then select the date from the first table concatinate them all and insert to the second table .