Error in incremental

Anonymous — Thu, 14 Mar 2013 05:04:04 GMT

I have wrote Store Procedure like this

CREATE PROCEDURE SP1_sample

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

Re: Error in incremental

Thu, 14 Mar 2013 09:02:29 GMT

Hi,

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

This is SQL related more than Qlikview...