Hi,
I have a stored procedure returning a table variable.
İnside Stored procedure i am declaring a table variable as
DECLARE @Result TABLE
(
CUSTOMER NVARCHAR(50),
MATERIAL NVARCHAR(50) ,
ORDERS int,
STOCK int,
DATE1 datetime
)
at the end of the procedure i'm returning table variable as
SELECT * FROM @Result
and stored procedure returns a resultset.
I want to get this results into Qliksense
I've already tried
-------------
Load *;
SQL execute dbo.stored_procedure;
-------------
STOCK:
LOAD
CUSTOMER AS %KEY_CUSTOMER,
MATERIAL AS %KEY_STOCK,
MATERIAL AS %KEY_MATERIAL,
ORDERS AS ORDERS,
STOCK AS STOCK,
Floor(NUM(DATE1)) AS [%KEY_CALENDAR];
SQL EXECUTE QlikSense.dbo."myproc";
-----------------
result are allways empty.
Any suggestions will be much appriciated.
Thank you.
