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

[#1]

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

[haymarketpaul]

I think this post might help you...

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

[#3]

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

[ksmccann]

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

SET NOCOUNT ON;

[erichshiino]

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

[luciano_garcia]

This worked for me !