Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
yourssiraj
Contributor

Error in incremental

hi

I have wrote Store Procedure like this

CREATE PROCEDURE SP1_sample

as

Declare @i as Int;

Declare @j as Int;

declare @C as Int;

create table #tab1temp(firstclum Numeric(20,2),secondcolum Numeric(20,2));

begin

select i=0;

select j=10;

select C=0;

          while (@i<=@j)

          begin

 

                    insert into #tab1temp values(@i,(@j-1));

                    select @i += 1;

          end

 

          select * from #tab1temp;

end

   

execute SP1_sample;

in this code value is inserting in Temp table #tab1temp but value is not incrementing 'select @i += 1;' in this part of code

can anyone help me how to increment  variable and how to insert into Temp Table...

1 Reply
Not applicable

Re: Error in incremental

Hi,

I think you should ask this question in http://stackoverflow.com/

This is SQL related more than Qlikview...

Community Browser