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 |
|
mbaughan
Starting Member
1 Post |
 Posted - 2010-07-29 : 10:24:18
|
| Hi,I have 3 tables, Types, Samples and samplesfortypes. Types and Samples are being populated by an import process, however I need to populate the samplesfortypes table with the TypeID of the Types table and the SampNum of the samples table. Is this at all possible in MS SQL 2008?Thanks. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-24 : 06:02:54
|
| select t1.typeid,t2.SampNum from Types as t1 inner join Samples as t2 on t1.keycol=t2.keycolMadhivananFailing to plan is Planning to fail |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-24 : 07:55:49
|
| who do you determine what all values of Types and Samples should be put together in a record in samplesfortypes------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Import data to a joining table