Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
wdchristensen
Specialist
Specialist

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).

usp_withTmpTbl_QlikSenseExample_01.png

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

usp_withTmpTbl_QlikSenseExample_02.png

usp_withTmpTbl_QlikSenseExample_03.png

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

https://community.qlik.com/message/1411505#1411505

0 Replies