Need help to make a sql query

07/06/2011 09:09 Svinseladden#1
i'm adding mobs and i use shtool.

the new mobs comes in both a sdata and csv file.

but anyway i need to add mobId 3005+ in the MobItems and insted of adding 3005 - 3100 manualy there has to be a way for sql to make that for you?

trying :

/*

Run the 2 lines below once to set start parameter

declare @MobId as int
set @MobId = 3006


*/




/* Inserting the first 9 lines for the first MobId */

insert into dbo.MobItems ()
select @MobId,1,0,0 -- MobId,ItemOrder,Grade,DropRate

insert into dbo.MobItems ()
select @MobId,2,0,0 -- MobId,ItemOrder,Grade,DropRate

insert into dbo.MobItems ()
select @MobId,3,0,0 -- MobId,ItemOrder,Grade,DropRate

insert into dbo.MobItems ()
select @MobId,4,0,0 -- MobId,ItemOrder,Grade,DropRate

insert into dbo.MobItems ()
select @MobId,5,0,0 -- MobId,ItemOrder,Grade,DropRate

insert into dbo.MobItems ()
select @MobId,6,0,0 -- MobId,ItemOrder,Grade,DropRate

insert into dbo.MobItems ()
select @MobId,7,0,0 -- MobId,ItemOrder,Grade,DropRate

insert into dbo.MobItems ()
select @MobId,8,0,0 -- MobId,ItemOrder,Grade,DropRate

insert into dbo.MobItems ()
select @MobId,9,0,0 -- MobId,ItemOrder,Grade,DropRate


/* Changes the parameter to current value +1 */

set @MobId = @MobId +1

but well it don't work hehe. anyone have a better idea to what i should run for it to make all the mobitems lines? 3005-3100 with 1-9 for the droprate?

if this is posible in the shtool tell me that too please.