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 - 2001-09-13 : 10:12:16
|
| Dan writes "How do I making duplicate records with a counter.I know how to take out duplicated records but I wand to make duplication.The database has a table named as ADVO_Count. In thetable has a field called family_Count containingvariable number like 0,1,5,15,58 or xxx (int) data,with other fields? I need to duplicate the recordsbased on those numbers in this field. If family_Count>1 then duplicate the record ###-1 times. And out putthis data in to another table (we may call it finish).The same thing explain in another way:sql that repeat a row many times is the value "family_Count" column. Like this:ID ¦ family_Count 1 ¦ 32 ¦ 53 ¦ 24 ¦ 6sql results:ID11122222334444Could you please give me a SQL script answer? Ichecked curser related questions even the tek-tips.comstill did not get much help.Thank you very much in advance.Dan Yangdanqyang@yahoo.com" |
|
|
|
|
|
Making duplicate records