Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

5 Replies
haymarketpaul
Creator III
Creator III

I think this post might help you...

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

Not applicable
Author

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
Partner
Partner

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

SET NOCOUNT ON;

erich_shiino
Partner
Partner

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
Contributor III
Contributor III

This worked for me !