Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store procedure not returning any data

Hello everyone,

Store procedure is not returning any data when executed in qlikview. But the same stored procedure can be executed successfully in SQL management studio and it returns data. Please help.

4 Replies
MK_QSL
MVP
MVP

Without checking your store procedure, no one can answer you. Kindly provide your script of stored procedure.

Thanks...

Not applicable
Author

I used the following stored procedure.

Qlikview Script:

Sql

Exec  E5SEA_BAL_DATA.dbo.SP_JobCardDataExtract "TimeStamp";

In place of TimeStamp I use a 18 digit binary number.

The script shows no error after executed and returns no data (not even field names).

But when I execute the same script in Sql Management studio it works and returns data.

Sql Management Studio Script:

Exec  E5SEA_BAL_DATA.dbo.SP_JobCardDataExtract "TimeStamp";

Not applicable
Author

Hi Ranjit,

Did u resolved? what is the issue. I am also in same situation.

Thanks.

johnjustus
Contributor III
Contributor III

Hi All,

I have the same problem.

Does any one has any idea why this script don't return any data in Qlikview

exec spRAD.dbo.Vendorscorecard '02/21/2017';

However if I  execute the same script in Sql Management studio it works and returns data.

Thanks