Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion III

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

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

Highlighted
Contributor III
Contributor III

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

Sure. Here it is

Highlighted
Contributor III
Contributor III

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

Sorry, same result. Weird!

Highlighted
Champion III
Champion III

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

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;

Highlighted
Master III
Master III

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

Pl Try this

SQL

SELECT x,y

INTO ##temp

FROM tab;

sql select x,yfrom ##temp

Drop table ##temp;