7 Replies Latest reply: Jun 2, 2016 10:32 AM by Laxmaiah Chowdary RSS

    Calling Stored Procedure in Qlikview

      Hi Guys

       

      I have a Sql Stored Procedure which has 2 input parameters and 2 output parameters . I am calling it in a following ways:

       

       

      Load * ;

      Sql

      Declare @out int

      Declare @out1 int

      Exec LMS.dbo.Sp_TestQlikview 1,7,@out Output,@out1 Output

      Select @out as Output

      Select @out1 as Output1;

       

       

      The problem is that i am getting only Output in Qlikview not Output1.