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 derfloh 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
Joined
Aug 10, 2011
Messages
31
Location
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
ooops never mind... i got it
thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question Question
Duplicate yes
Replies
5
Views
618
strongm
strongm
2009luca
  • Locked
difficult to crteate a query very complicated
Replies
9
Views
2K
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question Question
possible to use xml2 or Set WHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1"), instead code in message
Replies
5
Views
985
2009luca
2009luca
sal21
  • Question Question
printing picturebox to the default printer
Replies
2
Views
189
henry crown
henry crown
Swi
  • Locked
  • Question Question
Printer.Print to PDF
Replies
16
Views
2K
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top