Pedido query

[testemuonline]

ola galera teria como colocar essa query pra mim para roda automaticamente em cada 2 minutos??


TRUNCATE TABLE dbo.webRankingCharactersResets

INSERT INTO webRankingCharactersResets (account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)

Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by resets desc

TRUNCATE TABLE dbo.webRankingCharactersResetsMonth

INSERT INTO webRankingCharactersResetsMonth (account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)

Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,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,resetsweek,resetsmonth,class)

Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,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,resetsweek,resetsmonth,class)

Select TOP 200 AccountID,Name,cLevel,PkCountweb,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by Mresets desc, resets desc

TRUNCATE TABLE dbo.webRankingCharactersLevel

INSERT INTO webRankingCharactersLevel (account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)

Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by cLevel desc, resets desc

TRUNCATE TABLE dbo.webRankingCharactersResetsWeek

INSERT INTO webRankingCharactersResetsWeek (account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)

Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by resetsWeek desc, resets desc

 

[gRamos]

Por favor, Entrar ou Registrar para ver o conteúdo das citações!

Porque voê quer q ela rode de 2 em 2 mn? Que web vc ta usando ?