Hi!<br><br>I have a table with this columns<br><br>ID-identity<br>QT- INT<br><br>A need to do a sql that repeat a row many times is "QT" column. Like this:<br><br>Table rows<br>ID ¦ QT<br>1 ¦ 3<br>2 ¦ 5<br>3 ¦ 2<br>4 ¦ 6<br><br>a need a sql with this results:<br>ID<br>1<br>1<br>1<br>2<br>2<br>2<br>2<br>2<br>3<br>3<br>4<br>4<br>4<br>4<br>4<br>thanks in advance and sorry about my english. I'm from brazil and a i still learning!
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HOW TO DUPLICAT ROWS!
- Thread starter FLUZZI
- Start date
- Status
Similar threads
- Locked
- Question