This content has been marked as final.
Show 2 replies
-
Re: Executing a stored procedure in Qlik Sense.
omar bensalem Mar 5, 2018 7:01 PM (in response to Mahesh Tendulkar)Please refer to this; it might help :
Store a QlikSense table directly into an SQL table using the script.
-
Re: Executing a stored procedure in Qlik Sense.
Jonathan Dienst Mar 6, 2018 12:30 AM (in response to Mahesh Tendulkar)Your code does not appear to be a stored proc. I assume you are using MS SQL Server. The convert() function is failing because the string ' ' cannot be converted to a numeric type (money in this case) and the second convert has a trailing comma (or maybe that's just a typo on the post).
"Select...into" does not return a recordset, so this code as posted will fill the temp table but will not return any data to QS, so I am not sure what you mean by "returns the expected no of rows through Qlik Sense'.