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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert into a new table

Status
Not open for further replies.

harfri

Programmer
Mar 5, 2010
17
NL
Who can help me out?
I have a table with a balance in USD with 2 records

Table 1
Date. Balance
1-Jan-2018 100 USD
5-Jan-2018 200 USD
I would like to know how i can create a new table based on Table 1
The new table should have the following records
Date. Balance
1-Jan-2018 100 USD
2-Jan-2018 100 USD
3-Jan-2018 100 USD
4-Jan-2018 100 USD
5-Jan-2018 200 USD
6-Jan-2018 200 USD
7-Jan-2018 200 USD
8-Jan-2018 200 USD
Etc etc
Untill the end of the year the balance will be 200 USD so the new table
so have 365 records.

If you know how i can insert the new records in the new table i would be very happy!


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top