AptDev
asked on
Create a View with every day of the month, programmatically in SQL
Experts,
I've got a table that shows Begin_Date, End_Date, Exchange_Rate. The rate may change weekly.
I'd like to create a view that lists every day of the month, with the exchange rate shown for that day.
Can you think of a way, in using SQL code, I can SELECT every day of the month, and link it to my Exchange Rate table?
I've got a table that shows Begin_Date, End_Date, Exchange_Rate. The rate may change weekly.
I'd like to create a view that lists every day of the month, with the exchange rate shown for that day.
Can you think of a way, in using SQL code, I can SELECT every day of the month, and link it to my Exchange Rate table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.