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!

Register Log in
  • 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!

SQL query to duplicate records X times

Status
Not open for further replies.
Timalaugh

Timalaugh

Programmer
Aug 10, 2011
31
US
Hi all...
I have an odd one.
I need to be able to duplicate a record thisMany times where ThisMany is a field in the record. The table I start with only has one record. The problem is I need to do it in one select statement. Any one know how to do this.

thanks very much

Tim
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
Duplicate yes
Replies
5
Views
159
strongm
strongm
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
909
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
220
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How remove duplicate values when taking data from excel to VB 6?
Replies
2
Views
134
Niki_S
Niki_S
f0rg3tfu1
  • Locked
  • Question
circular reference caused by alias in query definition
Replies
7
Views
330
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top