topic Help with resultset return by SQL stored procedure in QlikView

Help with resultset return by SQL stored procedure

Wed, 26 Dec 2012 12:38:06 GMT

Hi,

I am using SQL stored procedure to get data from the database, the stored procedure returns multiple tables as result set.

But in QlikView i am getting only one table i.e. first table of resultset, how can i play with others table returned by stored procedure.

I am using below syntax, plesae help me if i am doing anything wrong.

set v_FinancialYear = 2012-2013;

Resultset:

LOAD *;

SQL EXEC

RPT_Get_RecruitmentKPIData '$(v_FinancialYear)';

Thanks

Re: Help with resultset return by SQL stored procedure

trey_bayne — Fri, 12 Jul 2013 18:18:57 GMT

I'm hitting the same issue here. Did you ever figure this out?

Re: Help with resultset return by SQL stored procedure

Colin-Albert — Tue, 20 May 2014 17:02:34 GMT

QlikView can only see the first result set returned by a stored procedure.

You will have to modify your stored procedure to output the data in a different way, either to separate tables that can loaded into QlikView, or build a single results table in the stored procedure that is populated with each result set in turn and then output at the end.