Latest Activity
I can't seem to create a base view from a query that uses a temp table. From looking around online/on the forums, this seems like an intentional limitation due to the session-limited lifetime of temporary tables. However, this seems like a bad limita...
Base view baseview created from query Global Temp Table Create Base View Baseview SQL Server INDEX Temp Tables
Hello, When creating a base view from query, I am always successful when creating a base view from query when I do a straight select with condititions. However I noticed when I try to put in a query where I create temp tables it does not work. Is there...
I have created a base view from query which contains parameters that I need to pass in order to get the result set. Base view name is bv_root_table. Parameter for the base view that is required that we pass is AccountID field. I am trying to execute a...
Invalid query in create base view from query View without search methods baseview created from query Parameter Subquery
I am able to create a base view from query, and do not get any error messages when creating it, given the instructions. However, when I attempt to execute it, I get following error message. Code is fine, and it runs with no issues and returns results, ...
Related to: Invalid query error using Create base view from query
Hello, Can a view created from a stored procedure be joined with a view created from the "Create from query" option? I have a report that runs perfectly now. The report is generated from a view created from a stored procedure joined to a view created t...
I need to fetch list of all baseviews which are created from query. Kindly suggest how can we get the list in Denodo 6.0