Discussion Board for collaboration on QlikView Scripting.
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));
insert into #tab1temp values(@i,(@j-1));
select @i += 1;
select * from #tab1temp;
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...
I think you should ask this question in http://stackoverflow.com/
This is SQL related more than Qlikview...