Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 help query

Author  Topic 

kabon
Starting Member

48 Posts

Posted - 2013-09-04 : 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

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-09-04 : 05:49:07
SELECT @maxnumber = @maxnumber+@loop


--
Chandu
Go to Top of Page
   

- Advertisement -