Calling SQL SERVER - Stored Procs

[#1]

Can anyone please explain how to call a SQL stored procedure returning a big table of data from qlikview.

sp_text '20100101',''20100530'

This stored proc returns all data for all employees in the given date range, I want to capture all that data and display it in charts & tables in qlikview

I am struggling with the exact syntax of how to make this call & capture the resultset ?

Amit

[#2 · Accepted solution]

Your command should look like this:

SQL EXEC sp_text '20100101','20100530';

If you are loading the resultset into a table, something like this:

qvw_table_name:
LOAD *;
SQL EXEC sp_text '20100101','20100530';

Hope it helps

[#3]

Awesome ... Thanks a ton!!!

[#4]

Hi Amit,

Cold you share the exact script which you using to run the SQL Stored Procedure

[#5]

Hi Amit,

Cold you share the exact script which you using to run the SQL Stored Procedure

[#6]

XYZ_mis:
LOAD *;
SQL EXEC SP_abc 20100523,$(TODAY),'mycompany';

[#7]

I am getting an OLEDB error

OLEDB read failed

SQL EXEC sp_xyz

I think this might be something to do with the connection mode, My stored procedure writes data in the database and i read somewhere that we need to add "mode is write" at the end of the connection string

I have done that but it still giving me the same error !

I am able to execute the stored procs which are simple reads with no temp tables

Anyone knws how to sort this out ??

[rustyfishbones]

Or try this video

Qlikview EXECUTE SQL Stored PROC with Parameters in Qlikview by RFB 228 - YouTube