Can we call storedprocedure field into the QlikView?

[Anonymous]

Hi All,

Can we call the SQL storedprocedure field in QlikView directly?

Best Regards,

Shubham

[stevedark]

Hi there,

It is not generally considered best practice to connect to a Stored Procedure.  Is there a particular reason it has to be a procedure call and not a SELECT from a view?

To use a stored procedure you need to add the text (mode is write) after your connection string, eg:

CONNECT TO [Provider=SQLOLEDB..[...]..when possible=False](mode is write);

You will get warnings each time you open the document after doing this.

The procedure call itself is then done like this:

TableName:

SQL EXEC dbo.prc_ProcedureName;

Hope that helps,

Steve

http://www.quickintelligence.co.uk/