Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
vitaliichupryna
Creator III
Creator III

Execute stored procedure - no issues, no data

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

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vitaliichupryna
Creator III
Creator III
Author

Hi,

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

Thanks,

Vitalii