Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Extract data from #temp tables SQL Server

Hi All,

I tried to extract data from #temp tables to Qlik Sense. However load will extract zero records where as SQL Server shows records with same query.

Do i need to add any script to query,as of now written like

SQL

Select

--

#temptable;

Actually i am assuming that #temptables stored in virtual memory (not physical) in SQL Server so Qlik is unable to load records/data. Is it correct? please share you knowledge if you were experienced it.

Thanks, Nihhal.

5 Replies
Anil_Babu_Samineni

For me this sounds, There is Privileges problem to the schema?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anil_Babu_Samineni

Add each measure separately to the Master Item and call it out to needed color.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nihhalmca
Specialist II
Specialist II
Author

Hi, anyone of you assist on this please?

Ilya_Bobrov
Contributor III
Contributor III

Perhaps you can create some kind of view or materialized view? What is the need to use tmp tables?

gmenoutis
Partner - Creator II
Partner - Creator II

A #table has scope only within the session that creates it.

A ##table, on the other hand, is temporary but can be accessible from all sessions. It gets deleted when the last session that accessed it comes to an end. Maybe use ##?