I am trying to execute sql server procedure from qlikview. The procedure takes 2 parameters as input and returns and array of 3*3 i.e 3 colums and 3 rows.
The script executes without error when I just submit the input parameters and dont specify the output variables to hold the output data. In this case I am not sure whether my procedure is executed or not? How to verify whether procedure is executed or not?
when I declare variables to hold the output data and use them when calling the procedure it gives me an error 'TOO MANY ARGUMENTS FOR THE PROCEDURE OR FUNCTION'
Is it that we cannot return multiple recordsets?
Can you please give me the syntax for the same?