0 Replies Latest reply: Jul 28, 2017 2:56 PM by William Christensen RSS

    Loading Qlik Sense from a stored procedure with temp tables

    William Christensen

      I am trying to pull data from a stored procedure SQL Server 2016. Everything works great until I try to pull from a stored procedure that uses temp tables. I initially thought that it was a permissions issue with the service account connecting to SQL Server but apparently there are no special permissions required to create or drop temp tables.




      Additionally, I connected to the database in SSMS using the service account and was able to run the stored procedure with no issues. I suspect I could rewrite the code to use table variables on CTEs on the SQL side but this would be a huge pain since I have to pull from dozens of existing store procs with temp tables. Any help would be greatly appreciated!



      LIB CONNECT TO 'DB0123_ABC';





      SQL EXEC Apps_Custom_DHP.dbo.usp_MySimpleSPTest