Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
acex10
Starting Member
13 Posts |
 Posted - 2004-12-29 : 04:10:10
|
| Greeting.Please help me..When a new data is insert into Table A. how do i go about adding in 6 column in Table B with the same data that is insert in Table A?That mean if A is entered into Table A.and i need table B to have A1, A2, A3, A4, A5, A6 in a continuous column. so if i add B into Table A, Table B should have B1, B2,B3, B4, B5, B6. and B1 should be continued from A6.Please HelpThanks |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-12-30 : 14:13:24
|
| I can't understand what you're trying to do. Can you provide the actual example instead of genericizing it? And please answer the following questions, also:1) How is data being entered into Table A? From a form? From a Query? From a Data Import?2) It sounds like you are saying you want 6 values to go into 1 column in Table B. Is that correct? If so, are you saying you want 6 values separated by commas in one field? Or do you really mean that you need 6 rows added with one value per row?3) If the answer to 2 is that everything goes in one column, then when record B is added, do the values for B get added to the same field, same row as A? Or do they get inserted into their own row in Table B?---------------------------------------------------------------------------------Infoneering: Information Technology solutions engineered to professional standards. |
 |
|
|
acex10
Starting Member
13 Posts |
Posted - 2005-01-02 : 20:43:36
|
| Thanks. I get what u meant. I will figure it out. |
|
|
|
|
|
|
|
|
Increase Columns