You can translate the question and the replies:

Date Temporary Table

Hello All, I am trying to create a temporary table with two years worth of dates. Is this possible in VQL? I looked through the documentation and it doesn't look like we can call any looping functions. ***Similar procedure in MS SQL:*** Thanks, James
11-06-2019 15:39:58 -0400

1 Answer

Hi, I could [Create a temporary table in Denodo]( and then manually insert the dates for required duration. I found that an easier way was to create this table in the datasource and then making a base view of that table in Denodo. It was then easier to create a temporary table referencing that base view with a select statement. All of this information and syntax for creating the temporary tables is mentioned in the link that is mentioned before. Hope this helps!
Denodo Team
14-06-2019 12:16:20 -0400
You must sign in to add an answer. If you do not have an account, you can register here