By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,363 Members | 1,470 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,363 IT Pros & Developers. It's quick & easy.

SQL Table

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

for instance i had 2 tables earnings and earningsDescriptions.
in the earningsDescription table i have a column called DescriptionNames which is filled in by the user during the companies setup.

now i want those names in the EarningsDescriptions 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 ?
Apr 10 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,127
First copy only the structure and then select the date from the first table concatinate them all and insert to the second table .
Apr 10 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.