Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calling SQL SERVER - Stored Procs

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

7 Replies
Not applicable
Author

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

View solution in original post

Not applicable
Author

Awesome ... Thanks a ton!!! Beer

Not applicable
Author

Hi Amit,

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

Not applicable
Author

Hi Amit,

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

Not applicable
Author


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

Not applicable
Author

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
Master II
Master II