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 |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2002-06-22 : 09:48:15
|
| I'm using the following code to duplicate a row in a table:insert into dbo.[MESAJLAR] (M_KonuID,M_Yazar,M_Tarih,M_Zaman,M_Mesaj,M_YazanIP) select M_KonuID,M_Yazar,M_Tarih,M_Zaman,M_Mesaj,M_YazanIP from dbo.[MESAJLAR] where M_KonuID='255'It works fine but if there're multiple M_KonuID with value '255' then it only duplicates the first one, not all of them. What should I do for this? |
|
|
SqlZ
Yak Posting Veteran
69 Posts |
Posted - 2002-06-24 : 16:44:07
|
| It should work fine the way you have it. Meaning that if there is 25 records say for example with M_KonuID='255', it should insert all 25 of them to the dbo.MESAJLAR table. Are you sure there is not only 1 record with M_KonuID='255'? That is the only situation I can think of that it inserts only one. |
 |
|
|
|
|
|
Duplicating rows