topic stored Procedure from MSSQL in Qlikview in QlikView

Problem with Temp Table !!!! (stored Procedure from MSSQL in Qlikview)

Wed, 25 May 2011 07:39:02 GMT

Hello Community!

I have a stored procedure "

SQL exec DataBaseName.dbo.GetmarginOverview '01.03.2011', '04.05.2011'; "

But the procedure gives nothing back. How can I modify my exec statement, that I

will get something back.

Thanks in advance.

Werner

stored Procedure from MSSQL in Qlikview

haymarketpaul — Wed, 25 May 2011 08:45:01 GMT

I think this post might help you...

http://community.qlik.com/message/3223#3223

stored Procedure from MSSQL in Qlikview

Wed, 25 May 2011 09:01:27 GMT

Hello Paul !

Thanks for this link, this thread I know :-).

So, I find out that my call of the stored procedure is right.
I comented out from bottom to the top some parts of the procedure.
I think Qlikview dont accepts TemporaryTables.

// my code sniped in the stored procedure, which makes a problem for Qlikview ...

// in Management Studio this work well !!!

declare @BatchIDTable table(BatchID int)

insert into @BatchIdTable (BatchID)

on ind.InvoiceID = inv.InvoiceID

values (1)

/*select iny.BatchID

from Invoices inv

inner join InvoiceDetails ind

... and so on

How can I solve this ?
Thanks in Advance.
Werner

stored Procedure from MSSQL in Qlikview

ksmccann — Sun, 01 Apr 2012 18:13:58 GMT

if you put the following statement after the BEGIN of your SP it should resolve the issue

SET NOCOUNT ON;

Problem with Temp Table !!!! (stored Procedure from MSSQL in Qlikview)

erichshiino — Sun, 01 Apr 2012 20:46:20 GMT

Hi,

Temporary tables will work just fine. I had problems before because the store procedure returned a lot of warning messages or information messages when tables were create or populated.

As mentioned by ksmccann, you can add the

SET NOCOUNT ON;

and also, it might be necessary to add:

set ansi_warnings off

Hope this helps,

Erich

Re: Problem with Temp Table !!!! (stored Procedure from MSSQL in Qlikview)

luciano_garcia — Tue, 25 Oct 2016 20:40:23 GMT

This worked for me !