topic Re: Problem retrieving data from a Store Procedure in QlikView

Problem retrieving data from a Store Procedure

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I'm trying to retrieved data from a Store Procedure in Qlikview. When I execute my qvw in the QlikView's console I see the connection to the base and then... nothing happend. It's like the SP don't retrieved any record but when I execute the SP in the SQL Server's Client I get data.

This is my load script:

LOAD *;

SQL EXEC T1000.TOA.[dbo].[SP_AGENDA_DISP_VS_QUOTA_TOA];

And this is my connection string:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=indicadores_dw;Data Source=T1000;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PC025-PC;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is KQdXESdOUbMaM);

I got access to the SP's code, when I read it I saw the funtion openrowset as the only one that can give me a problem (I supposed).

This is SP's pseudocode:

SELECT * INTO #PEND

FROM openrowset('sqloledb','BlaBlaBla';'BlaBlaBla';'BlaBlaBla','exec TRAZ_PEDIDOS.DBO.GET_PEND')

SELECT bla,

bla,

bla

INTO #INFORME

FROM (SELECT * FROM openrowset('sqloledb','BlaBlaBla';'BlaBlaBla';'BlaBlaBla','select * from TRAZ_PEDIDOS.dbo.QUOTA_BLABLA ') Q

INNER JOIN

( SELECT bla,

bla,

bla

....

The other part of the code its just left joins, right joins and others ...

Any one has faced on to this problem? Any idea? I'm trying hard to solve this problem but I don't have succeded.

Best Regards,

Leandro.

Re: Problem retrieving data from a Store Procedure

Clever_Anjos — Mon, 14 Mar 2016 20:40:54 GMT

Please check if your procedure has a

SET NOCOUNT ON

Re: Problem retrieving data from a Store Procedure

Anonymous — Mon, 14 Mar 2016 20:50:31 GMT

The procedure hasn't a SET NOCOUNT ON

Re: Problem retrieving data from a Store Procedure

Clever_Anjos — Mon, 14 Mar 2016 20:51:49 GMT

I think that´s the problem

Re: Problem retrieving data from a Store Procedure

Clever_Anjos — Mon, 14 Mar 2016 20:56:47 GMT

Some other threads with same problem

'Set NoCount ON' in Stored Procedure

Re: Load from MSSQL stored procedure with / without temporary table

Re: Problem retrieving data from a Store Procedure

Anonymous — Tue, 15 Mar 2016 14:10:05 GMT

It works!

And I didn't need to modify the SP, my load script looks like this:

LOAD *;

SQL SET NOCOUNT ON; SQL EXEC T1000.TOA.[dbo].[SP_AGENDA_DISP_VS_QUOTA_TOA];

Re: Problem retrieving data from a Store Procedure

Clever_Anjos — Tue, 15 Mar 2016 14:23:20 GMT

Good