2 Replies Latest reply: May 20, 2014 1:02 PM by Colin Albert RSS

    Help with resultset return by SQL stored procedure



      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;



      LOAD *;

      SQL EXEC

      RPT_Get_RecruitmentKPIData '$(v_FinancialYear)';