SP doesn't return data

[rsdhavle]

We are calling one SP which contains below steps:

1. Creates a table
2. Loads data into the table
3. Selects all records from the same table

When i am trying to get data from this SP into Qlikview document it doesn't return any rows however SP executes successfully in database. I am using SQL server

Qlikview does not show a single field after execution is completed.

[alexandros17]

Check the syntax

[rsdhavle]

Syntax is correct. When i run other SP only with Select statement Qlikview is showing data

[its_anandrjs]

What syntax you use can you publish to check and once check it may be in some line there is error in the syntax.

[Anonymous]

I am doing the same thing for loading access of users :

Visibilite:

LOAD

    IDSALARIE, keyVisibilite;

SQL execute QVW_get_salaries_vcc $(vIdClient);

[jaimeaguilar]

Hi,

have you checked that the format of what it's in vIdClient is the same in QlikView and in your Database?

regards

[Anonymous]

Hi,
I also tried executing Stored procedures containing Link to other SQL server and it dint work, but I found solution for this problem, We have to create 2 Stored procedures to make this thing work and below are the steps
1. Create Table in in Actual DB to hold values from Linked server.
2. Create first Stored procedures to insert data from Linked server to actual DB
3. Create Stored procedures to fetch data from Table of Actual DB
Then execute both the stored procedures sequentially in QlikView to get the result.
Since QliKView can't read data from Stored procedures having Link to other server, This might work.

[Anonymous]

Hi,

Since you are using creating table in SP and processing data from that, you should use ODBC connection in QliK View script and open the conneciton in Write mode as below.

ex.:ODBC CONNECT TO [DB](Mode is write)