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 |
|
feejaz
Yak Posting Veteran
68 Posts |
 Posted - 2007-12-15 : 06:44:03
|
| i have a table in the below shown format Values Items.......................................................TABLE1Customer1 20 Fuses Customer2 30 Screws Customer3 40 Fuses Customer1 45 Fuses Customer3 78 BatteriesCustomer1 40 Screwsnow i want to add the values of screw of customer1 and insert in a table in one field as shown below Screws Fuses Screws .................................TABLE2Customer1 65 (total of above) 115 40 Custoerm2 ------------------------------------NOW ADD VALUES IN THE ABOVE WAY AND INSERT IN THE TABLE 2ThanksNavi |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-15 : 07:32:57
|
>> screw of customer1do you work for the phone company? 
elsasoft.org |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-12-15 : 12:58:49
|
| The first thing I would do is split the items in table 1 , from what I can see, you've got : Values = Customer1 Items = 20 Fusesnce you'vr split them into 3 colums , with maybe the third column called "ItemType" which could have a foreign Key to a ItemType tableCould you explain what the 115 represents?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
problem-Adding numeric values in the database