Importing Data from SQL Server 2016 from Stored Procedure with a #TempTable (Temporary table)

    When creating your stored procedures be sure to “SET NOCOUNT ON;


    On my SQL Server, the default setting is OFF so if explicit initialization is excluded the default behavior will create an error on the Qlik side (load script).



    If you didn’t set up your stored procedure correctly you will likely see something like the example below:




    ** I would like to thank Gareth Wilson for teaching me how to correct this error! **