topic Re: Store procedure not returning any data in QlikView

Store procedure not returning any data

Tue, 05 Aug 2014 02:59:44 GMT

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.

Re: Store procedure not returning any data

MK_QSL — Tue, 05 Aug 2014 07:59:35 GMT

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

Thanks...

Re: Store procedure not returning any data

Tue, 05 Aug 2014 08:04:36 GMT

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";

Re: Store procedure not returning any data

Fri, 26 Sep 2014 14:19:19 GMT

Hi Ranjit,

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

Thanks.

Re: Store procedure not returning any data

johnjustus — Tue, 21 Feb 2017 20:05:01 GMT

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