SQL-session for different queries

[Anonymous]

Hi everybody,

I refer from a database over an extended SQL query a data base that will help in further steps of statistical analysis to be driven.

Statistical analyzes repeatedly ask the first session (table1) from:

"(Select * from session.table1)"

At the end of only one table should arise in the individual months and years corresponding values are to be assigned.

A SQL script that writes all the individual indicators into a table would lead to excessive nesting and make the calculation very slowly.

I want to solve the queries largely on SQL, so the capacity of the SQL server is used and the low-power computer of the user is more likely.

The SQL commands can be executed all and provide accurate results. Now the question is whether it is possible to integrate the intermediate tables in SQL in a command in QlikView or whether it is better to read in the first table and to perform further calculations locally by QlikView.

Thank you for your suggestions and kind regards!

[Gysbert_Wassenaar]

The SQL commands can be executed all and provide accurate results. Now the question is whether it is possibleto integrate the intermediate tables in SQL

Yes, but not if you use separate sql commands to pull the data into Qlikview. You will have to execute and integrate everything on the server. Perhaps your local friendly database administrator is willing to write a stored procedure for you that does this. From Qlikview you need only execute that stored procedure and receive the result set that the stored procedure creates.