Use of SQL query with temp tables

[rsdhavle]

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

[Anonymous]

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

[rsdhavle]

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]

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]

Is that working Rohan

[rsdhavle]

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]

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