@hadeslan

CRIE UMA JOB PARA CADA UM DESSES CODIGOS

TRUNCATE TABLE dbo.webRankingCharactersResets
INSERT INTO webRankingCharactersResets (account,character,clevel,pkcount,resets,mresets,r esetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,reset sWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by resets desc
INSERT INTO webRankingCharactersLevel (account,character,clevel,pkcount,resets,mresets,r esetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCountweb,resets,mresets,re setsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by cLevel desc, resets desc
TRUNCATE TABLE dbo.webRankingCharactersResetsMonth
INSERT INTO webRankingCharactersResetsMonth (account,character,clevel,pkcount,resets,mresets,r esetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,reset sWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by resetsMonth desc, resets desc
TRUNCATE TABLE dbo.webRankingCharactersPk
INSERT INTO webRankingCharactersPk (account,character,clevel,pkcount,resets,mresets,r esetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,reset sWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by PkCountWeb desc, resets desc

TRUNCATE TABLE dbo.webRankingCharactersMasterReset
INSERT INTO webRankingCharactersMasterReset (account,character,clevel,pkcount,resets,mresets,r esetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCountweb,resets,mresets,re setsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by Mresets desc, resets desc

TRUNCATE TABLE dbo.webRankingCharactersResetsWeek
INSERT INTO webRankingCharactersResetsWeek (account,character,clevel,pkcount,resets,mresets,r esetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,reset sWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by resetsWeek desc, resets desc

DEIXE ELAS RODANDO DA MANEIRA QUE VOCE QUIZER QUE ATUALIZE OS RANKINGS DO MU SITE

OBS: AS TABELAS ESTAO ORIGINAIS MU SITE, CASO QUEIRA MUDAR FIQUE AVONTADE