Hi,
If anyone could help - that'd be really great.
Here is the situation:
I have two tables:
Table1:
AccNum--------------AccCurr----------------------AMT--------------BDate
112344----------------USD-------------------------150---------------2/28/2016
112344----------------USD-------------------------160---------------3/1/2016
112344----------------USD-------------------------170---------------12/1/2016
112344----------------USD-------------------------175---------------12/26/2016
Table2.
6/1/2016
6/2/2016
6/3/2016
6/4/2016
6/5/2016
6/6/2016
6/7/2016
6/8/2016
6/9/2016
6/10/2016
....till today
Basically, I need to create a query which would have existing records from Table1 and new records where dates in Table1 are missing so they would have the value from a day before. The desired result would look like
AccNum--------------AccCurr----------------------AMT--------------BDate
112344----------------USD-------------------------150---------------2/28/2016
112344----------------USD-------------------------160---------------3/1/2016
112344----------------USD-------------------------160---------------3/2/2016
112344----------------USD-------------------------160---------------3/3/2016
.................................................. ................................................
112344----------------USD-------------------------160---------------11/30/2016
112344----------------USD-------------------------170---------------12/1/2016
112344----------------USD-------------------------170---------------12/2/2016
112344----------------USD-------------------------170---------------12/3/2016
.................................................. .......................................
112344----------------USD-------------------------170---------------12/25/2016
112344----------------USD-------------------------175---------------12/26/2016
Thank you