Inset into top10

trying to make script insert into top 10 players items ill set this as a cronjob but kind stuck on how to link/nsert into the charname::

Code:

---

SELECT TOP 10 * FROM _JobRank WHERE JobType = 1 ORDER BY Rank
declare @CharName varchar(64)
set @CharName = 'Test'
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SD_TOKEN_01',100,0

---

or would this work

Code:

---

(SELECT TOP 10 CharName FROM _JobRank WHERE JobType = 1 ORDER BY Rank =
 (EXEC _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SD_TOKEN_01',100,0'))

---

bump any help please

bump again