topic Re: Use of SQL query with temp tables in QlikView

Use of SQL query with temp tables

rsdhavle — Wed, 04 Jun 2014 15:16:04 GMT

Can we use SQL query with temp tables in QLikview application to load the data?

Anonymous — Wed, 04 Jun 2014 15:17:51 GMT

You can create a stored procedure in SQL and use that Stored procedure in qlikview hope this helps.

rsdhavle — Wed, 04 Jun 2014 15:24:28 GMT

Yes we thought of this approach. Is that quite easy to use Stored Procs in Qlikview or there are any limitations?

What is the syntax of using it?

Anonymous — Wed, 04 Jun 2014 15:27:43 GMT

for example please see below code: Please let me know in case of any questions

TEST:

SQL

EXECUTE Schemaname.ATP.spBuildTestResults;

store TEST into [$(vAbstractQVDDir)TEST.qvd];

Anonymous — Wed, 04 Jun 2014 15:45:29 GMT

Is that working Rohan

rsdhavle — Thu, 05 Jun 2014 11:54:06 GMT

when we are trying to fetch data from SP it does not return any data in QVW however when I run the SP on database it does return rows

Anonymous — Thu, 05 Jun 2014 12:24:13 GMT

can you attach the qvw file , i will see if there is any issue in the script.