Shard database -> Programability ->Stored Procedures -> _TRAINING_CAMP_UPDATEHONORRANK
햐庚� 逑 햐殺 張宸� :
生�:
OPEN RankCursor
FETCH NEXT FROM RankCursor INTO @CampID
WHILE @@FETCH_STATUS = 0
BEGIN
IF @Ranking <= 5
BEGIN
SET @Rank = 1
END
ELSE IF @Ranking <= 15
BEGIN
SET @Rank = 2
END
ELSE IF @Ranking <= 30
BEGIN
SET @Rank = 3
END
ELSE
BEGIN
SET @Rank = 4
END
햐총僿� 權 刊凡� 顧� 翅 姦�..휀 逑 孼槪� 伴� 50
松 휴� 玟潺 簡殘 햐螺� 햐殺 臆� 50 :
Shard database -> Programability ->Stored Procedures -> _Begin_TrainingCampHonorRank
生�:
DECLARE @Ranking INT
SET @Ranking = 1
WHILE @Ranking = 50
簡殘 햐螺� 햐殺 훌疎滾�.