Discussion board where members can learn more about Qlik Sense Data Connectivity.
In one of my application, I need to use a stored procedure with three parameters as a data source.
The main problem is always finished without issues but doesn't return any data.
On community I found a possible solution: add SET NOCOUNT = 0; statement to the stored procedure, after adding statement I executed it again and still have the same result.
What can cause such a problem?
Does the SP return any values when executed in another environment (SQL MS / Toad etc)? Is that the last item returned from the SP?
Yes, SP returns data when I run it from MS SQL Server
May be try this way: