Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I'm hitting the same issue here. Did you ever figure this out?
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.