how to call store procedur from sql server in qlikview ?

[#1]

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

[Anonymous]

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.

[rbecher]

Hi,

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

LOAD...

SELECT function() ...;

Ralf

[bnichol]

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

B

[#5]

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,

/Y