SQL QUERY to QLIKVIEW

sona_sa — Tue, 16 Dec 2014 05:38:03 GMT

Hi,

I want to convert the sql query to QlikView Script. Below are the mentioned query. Also if it possible to convert into VB macro, it is also helpful for me to execute it by QV macro.

DECLARE @LLNO BIGINT;

DECLARE @LLBK BIGINT

SET @LLNO = 1;

WHILE @LLNO<=100

BEGIN

SET @LLBK =(SELECT DISTINCT LOID FROM [dbCertifiedInventory_Live].[dbo].QLIKVIEW_LOTID_IDENTITY WHERE SR_NO =@LLNO)

exec [dbo].[SP_QLIKVIEW_SINGLE_LOT_INSERT] @LLBK,'','','0','0','0','01-Mar-2013','31-Dec-2014',''

print 'success';

SET @LLNO = (@LLNO+1);

end;

Regards,

Amit Kumar

Re: SQL QUERY to QLIKVIEW

Gysbert_Wassenaar — Tue, 16 Dec 2014 13:36:21 GMT

That's not an sql query, but a block of code that appears to execute a loop that executes a stored procedure that inserts data into some table. This cannot be converted to Qlikview script. The best you can do is create a stored procedure that executes that block of code and call that stored procedure from the qlikview script: SQL EXEC [dbo].[MyNewSP];

topic SQL QUERY to QLIKVIEW in QlikView

SQL QUERY to QLIKVIEW

Re: SQL QUERY to QLIKVIEW