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!

Insert into a new table

Status
Not open for further replies.
harfri

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.

Similar threads

BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
158
carp
carp
BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
158
carp
carp
BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
231
carp
carp
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
103
mikrom
mikrom
ahadali79
  • Locked
  • Question
Getting a part of string
Replies
2
Views
123
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top