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:*** https://stackoverflow.com/questions/6125504/how-can-i-generate-a-temporary-table-filled-with-dates-in-sql-server-2000 Thanks, James
user
11-06-2019 15:39:58 -0400

1 Answer

Hi, I could [Create a temporary table in Denodo](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/temporary_tables/creating_temporary_tables/creating_temporary_tables) 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