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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-17 : 08:46:44
|
| Richard writes "I want to insert multiple records into the same fields at one time. How can this be done? When I create two INSERT statements, the last Insert statement values populate the database but the first statement values do not. Can I join the statements or how do I separate them so that both statements work? Any help is greatly appreciated. " |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-02-17 : 09:00:56
|
| Not entirely clear what you mean. Can you post your code, table definitions, and expected results.Mark |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-17 : 09:17:08
|
| Post the query you used. The following will work correctlyInsert into yourTable(column)Select somevalue from OtherTableMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Insert multiple records into same fields at one time