Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ch_thies
Contributor III
Contributor III

SQL temporary tables (phisical, local and global) does not return data

Hi everyone.

Does anyone knows a workaround to make this query to return data to QV? It works when running on SQL, but returns no data from QV load script.

Hints

1) Creating SP is not a solution due SQL permission/restrictions

2) SQL and connection is fine. It works when query does not create temp tables (phisical, #local or ##global ones).

Thanks in advance

test:

LOAD *;

SQL

select top 5 *

into ##tmp

from <table> with(nolock)

select * from ##tmp;

14 Replies
vishsaggi
Champion III
Champion III

Strange. It worked for me. Can you send us your actual script you are trying to use?

ch_thies
Contributor III
Contributor III
Author

Sure. Here it is

ch_thies
Contributor III
Contributor III
Author

Sorry, same result. Weird!

vishsaggi
Champion III
Champion III

Try this exact code? Use your correct usrname and password though.

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=<id>;Initial Catalog=<catalog>;Data Source=<dc>;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=<wid>;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is <pwd>);

SQL

SELECT TOP 100 fechaalta, fechabaja

INTO ##temp

FROM dw_suscripciones with(nolock);

select * from ##temp;

sasiparupudi1
Master III
Master III

Pl Try this

SQL

SELECT x,y

INTO ##temp

FROM tab;

sql select x,yfrom ##temp

Drop table ##temp;