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
ÊÛíÑ ÇáÑÞã Çááí ÈÇáÃÍãÑ.