topic Calling SQL SERVER - Stored Procs in QlikView

Calling SQL SERVER - Stored Procs

Tue, 25 May 2010 15:00:34 GMT

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

Calling SQL SERVER - Stored Procs

Tue, 25 May 2010 17:06:02 GMT

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

Calling SQL SERVER - Stored Procs

Tue, 25 May 2010 17:54:01 GMT

Awesome ... Thanks a ton!!!

Calling SQL SERVER - Stored Procs

Wed, 26 May 2010 05:38:28 GMT

Hi Amit,

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

Calling SQL SERVER - Stored Procs

Wed, 26 May 2010 05:38:54 GMT

Hi Amit,

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

Calling SQL SERVER - Stored Procs

Wed, 26 May 2010 15:14:25 GMT

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

Calling SQL SERVER - Stored Procs

Wed, 26 May 2010 15:32:50 GMT

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 ??

Re: Calling SQL SERVER - Stored Procs

rustyfishbones — Sun, 19 Feb 2017 23:23:31 GMT

Or try this video

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