Error in incremental

[Anonymous]

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...

[#2]

Hi,

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

This is SQL related more than Qlikview...