Discussion Board for collaboration related to QlikView App Development.
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.
I think this post might help you...
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
from Invoices inv
inner join InvoiceDetails ind
... and so on
How can I solve this ?Thanks in Advance. Werner
if you put the following statement after the BEGIN of your SP it should resolve the issue
SET NOCOUNT ON;
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
and also, it might be necessary to add:
set ansi_warnings off
Hope this helps,
This worked for me !