Execute stored procedure - no issues, no data

[vitaliichupryna]

Hi,

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?

Thanks,

Vitalii

[jonathandienst]

Does the SP return any values when executed in another environment (SQL MS  / Toad etc)? Is that the last item returned from the SP?

[vitaliichupryna]

Hi,

Yes, SP returns data when I run it from MS SQL Server

Thanks,

Vitalii

[BalaBhaskar_Qlik]

May be try this way:

https://community.qlik.com/t5/Qlik-Sense-App-Development/SP-not-returning-Data/td-p/1443191