consegui com essa

declare @AccountID varchar (10)
declare @Name varchar(10)
declare @ranksemana int
declare @credits int
Select top 1 @AccountID=AccountID,@Name=Name,@ranksemana=rankse mana from character order by ranksemana desc
Update DT_SHOP_CREDITS set credits=credits+10 where login=@AccountID
Update character set ranksemana=ranksemana+1
Update character set ranksemana=0