topic Shorter Optimize SQL Script in QlikView

Shorter Optimize SQL Script

Fri, 21 Oct 2011 06:32:45 GMT

can this script be shorten?

PERIODS:

LOAD

DOCNO,

POSTDATE

FROM DOCS.QVD (qvd);

JOIN LOAD

PERIOD,

[Starting Date],

[Ending Date]

FROM [ACCOUNTINGPERIOD.QVD] (qvd);

LOAD

DOCNO,

POSTDATE

FROM [DOCS.QVD] (qvd);

LEFT JOIN

LOAD

DOCNO,

PERIOD

RESIDENT PERIODS WHERE POSTDATE >= [Starting Date] AND POSTDATE <= [Ending Date];

STORE * FROM SSH INTO SSH.QVD;

Shorten in a way I can lessen the number of LOADs from 4

its_anandrjs — Fri, 21 Oct 2011 06:50:01 GMT

Hi,

You can use like

PERIODS:

LOAD

DOCNO,

POSTDATE

FROM DOCS.QVD (qvd);

JOIN LOAD

PERIOD,

[Starting Date],

[Ending Date]

FROM [ACCOUNTINGPERIOD.QVD] (qvd);

LEFT JOIN

LOAD

DOCNO,

PERIOD

RESIDENT PERIODS WHERE POSTDATE >= [Starting Date] AND POSTDATE <= [Ending Date];

STORE * FROM SSH INTO SSH.QVD; //what is the meaning of this code

if there is table SSH so use it like

STORE SSH INTO SSH.QVD;

Rgds

Anand