Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Without checking your store procedure, no one can answer you. Kindly provide your script of stored procedure.
Thanks...
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";
Hi Ranjit,
Did u resolved? what is the issue. I am also in same situation.
Thanks.
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