Can not execute SQL SEVER Stored Procedure in Qv

[#1]

Hi Everyone,

Anybody knows how to load data from stored procedure?

I need to load data from sql server Stored Precedure in Qlikview. But each time no data or table loaded without error message.

Connect to sql server OK. The script work fine in sql server client.

I wrote the script like this:

Below is the ending snapshot after finished reloading.

[#2]

You're right! Finally I solved my issue. I add "SET NOCOUNT ON;" in the SP script. Thank you and you all.

The final script i used in Qv is like this, very simple:

1. Connection String

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=[DATABASENAME];Data Source=[SOURCENAME];Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=[WORKSTATIONNAME];Use Encryption for Data=False;Tag with column collation when possible=False];

2. SQL String

sql

exec Stored_ProcedureName 100,'A';