topic how to call store procedur from sql server in qlikview ? in QlikView

how to call store procedur from sql server in qlikview ?

Thu, 07 May 2009 16:38:07 GMT

Hi, I need to load a table from store procedure in sql server 2000 into qlikview. The connection with ole db or odbc both is succeed , after that I load the store procedure by typing sql execute procedurename; in edit script. But the result come up the list box is empty ... no field come up as a result the reload is succeed.

Is anyone can help me ? thanks

how to call store procedur from sql server in qlikview ?

Anonymous — Thu, 07 May 2009 21:10:54 GMT

I tried to do something like this once, with no much success.
Try to solve this by making the procedure to export the result into a file, and after that read the file in QV script.

how to call store procedur from sql server in qlikview ?

rbecher — Thu, 07 May 2009 21:21:29 GMT

Hi,

maybe, you could wrap it with a user defined function? And then load like this

LOAD...

SELECT function() ...;

Ralf

how to call store procedur from sql server in qlikview ?

bnichol — Fri, 23 Jul 2010 14:13:03 GMT

Try

SELECT * FROM OPENQUERY(LOCALSERVER, 'SET FMTONLY OFF exec {fully qulified name});

Where the fully qualified name is something like "schema123"."dbo"."sp_procedure_name"'

This should return all values from the specified stored procedure.

Good Luck

Re: how to call store procedur from sql server in qlikview ?

Mon, 17 Dec 2012 09:39:55 GMT

Have you figure out how to do this? I've tried bnichol clever select but it gives me errors about syntax error or access violation.

Thank you in advance,