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 - 2004-06-03 : 08:16:30
|
| mkp2004 writes "I have a problem with my DTS export....Here I have a table employee tableid Employee_id Name age Sex1 300 Manu 23 m 2 301 Anu 45 f3 302 Vinu 56 mNow I want to duplicate the records in this table just by changing the employee_id(eg:- adding 1000 to the 1st 3records. Now I will have a data set. Like that I want to make 100 sets. It will look like....employee tableid Employee_id Name age Sex1 300 Manu 23 m 2 301 Anu 45 f3 302 Vinu 56 m4 300+1000 Manu 23 m5 301+1000 Anu 45 f6 302+1000 Vinu 56 m7 300+2000 Manu 23 m8 301+2000 Anu 45 f9 302+2000 Vinu 56 m..................................................................................Like that 10 sets of data. here if u notice the only change is the employee_id where it should be made in a loop to generate 10 sets.This is needed as a creteria for DTS..So please help me very urgently " |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-06-03 : 19:12:46
|
| Duplicate:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=35600 |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-03 : 19:14:12
|
| Have you noticed all these posts have the same weird name examples. lol I'm thinking HOOOOOOMEWORK!!!MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-03 : 19:48:39
|
| You wouldn't use dts for this unless it was an artificial question.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Duplicating records in the same table