Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
replicate data based on record criteria
- Thread starter cdw0308
- Start date
Couple of ways depending on your setup.
This article explains how to use CURSORS and SELECT statements to loop through your table and INSERT the necessary rows. It should flow something like this:
UPDATE current cable_num fields to include the '_1' on the end since they probably will all have at least 1 iteration of cond_num.
Loop through the table finding (cond_num - 1) for each distinct cable_num and then insert that many rows with the increasing cable_num concatenation.
All lessons learned from the School of Hard Knocks........at least tuition is cheap.
This article explains how to use CURSORS and SELECT statements to loop through your table and INSERT the necessary rows. It should flow something like this:
UPDATE current cable_num fields to include the '_1' on the end since they probably will all have at least 1 iteration of cond_num.
Loop through the table finding (cond_num - 1) for each distinct cable_num and then insert that many rows with the increasing cable_num concatenation.
All lessons learned from the School of Hard Knocks........at least tuition is cheap.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question