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

    Help with resultset return by SQL stored procedure

      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