|
kabon
Starting Member
Indonesia
48 Posts |
 Posted - 09/04/2013 : 04:26:28
|
I have query like this :
declare @maxnumber int,@generate int,@loop int
set @maxnumber = 0
set @generate = 15000 --jumlah yang input
set @loop = 1
select @maxnumber = MAX(RECID) from a where COMPANY_BOOK = 'ID0010002' and left(RECID,1) = 7 --cabang nya
while @loop <= @generate
begin
print @maxnumber+@loop
set @loop = @loop + 1
end
How to make this query which is that print into select into.
Thank you |
|
help query
