Query Para Premiar Tops Mensal MuSite Daldegam

Código:

DECLARE @username varchar(10); DECLARE @count int; SET @count = 0; DECLARE C CURSOR FOR SELECT TOP 3 [username] FROM [webSite].[webRankingCharactersResetsMonth] ORDER BY [resetsmonth] DESC OPEN C FETCH NEXT FROM C INTO @username WHILE @@FETCH_STATUS = 0 BEGIN IF @count = 0 UPDATE [webCash] SET [amount]=[amount]+100 WHERE [username] = @username ELSE UPDATE [webCash] SET [amount]=[amount]+20 WHERE [username] = @username SET @count = @count + 1; FETCH NEXT FROM C INTO @username END CLOSE C DEALLOCATE C UPDATE [MuOnline].[Character] SET [resetsmonth] = 0 // certifique-se de qual é sua table na character

Creditos: BrunoDaniel